Formula #ERROR when empty

[Gérard Ducouret]

Hello,

As the "Notes" field can't be added as a Published field, I copied it in a
Text(x) field.
In Project Pro 2003 the following formula works fine : [Notes]

But in PWA, if it works when the Notes field contains some text data.
It returns #ERROR when it's empty.
Why ?

Thanks for your help!

 

[Marc Soester]

Hi Gerard,

Since you use a textfield, you will need to capture all evantualities. You
have to capture the "empty" part with an if statement
Something like:
IIf([Textfield]="","",[textfield])

Did you know that you can actually add the Notes column to PWA? You can find
it within the Admin tab under Manage Views, (View Type = Project). Within
these views there is a field called Notes, wich will display the notes per
Task on this view.

I hope this helps

 

[Gérard Ducouret]

Hi Marc,
Two thanks for the two answers !

Gérard

Hi Gerard,

Since you use a textfield, you will need to capture all evantualities. You
have to capture the "empty" part with an if statement
Something like:
IIf([Textfield]="","",[textfield])

Did you know that you can actually add the Notes column to PWA? You can find
it within the Admin tab under Manage Views, (View Type = Project). Within
these views there is a field called Notes, wich will display the notes per
Task on this view.

I hope this helps

--
Marc Soester
State Manager: EPM

Hello,

As the "Notes" field can't be added as a Published field, I copied it in a
Text(x) field.
In Project Pro 2003 the following formula works fine : [Notes]

But in PWA, if it works when the Notes field contains some text data.
It returns #ERROR when it's empty.
Why ?

Thanks for your help!