151529 - no subject - Hi,\n\nAnybody has a clue as to why, whe

charlesb454 over 9 years ago

Hi,

Anybody has a clue as to why, when used for a task report column, the expression below blanks all column values?

if(isnull(pv!avgResponseTime), Completion(), todecimal(Completion()) - todecimal(pv!avgResponseTime[1]))

Changing the expression to

if(isnull(pv!avgResponseTime), Completion(), todecimal(1) - todecimal(pv!avgResponseTime[1]))

Gives the correct results. Thanks.

Discussion posts and replies are publicly visible

Parents

0 charlesb454 over 9 years ago

Thanks for your time. It is declared as 'Multiple' (Variable can store multiple values). Note that I tried the above with a non array variable and got the same behavior. It seems like whenever I involve Completion() in the expression I get the issue, although doing Completion() - Completion(), for example, will work and display 0.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 charlesb454 over 9 years ago

Thanks for your time. It is declared as 'Multiple' (Variable can store multiple values). Note that I tried the above with a non array variable and got the same behavior. It seems like whenever I involve Completion() in the expression I get the issue, although doing Completion() - Completion(), for example, will work and display 0.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data