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

@charlesb Is pv!avgResponseTime a multi valued or array variable?

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.

From my experience I could say that isnull function won't work on the array variables in the report. Instead I would recommend to use length function. Few might think that using length function in case of null valued variable results in an error, but in portal report it executes perfectly. Actually in your case, isnull always returns false.

As you are saying that it isn't working on non Multiple type variable, this is some thing which should be given thought of. I didn't use this till now, but I would get back to you if I get leads. Just aimed at adding a suggestion in case of null check on array variable.

Thanks for your input - for now I'll try to work around the issue by doing the calculation outside the portal report. As a note, isnull returns true if the pv is not defined on some instances (older versions) of the underlying process model.

@charlesb If needed, probably you could overcome that behavior by depending on the pm!version property. I remember doing some thing similar few months back.

charlesb The problem is being seen when the todecimal(pv!avgResponseTime[1])) is evaluating to null. Completion() is working perfectly as per my observations. Control the null valued array variable by making use of index function.

I believe the following expression should solve the issue:

if(
length(
pv!avgResponseTime
) = 0,
Completion(),
todecimal(
Completion()
) - todecimal(
index(
pv!avgResponseTime,
1,
0
)
)
)