NaN and -Infinity in Expression Boxes

[Jay W]

I'm using expressions to store and/or display some calculated values such as
dollars per transaction (total dollars/total transactions) and margin %
(revenue - expenses / revenue). The issue I face is that sometimes the
numbers involved are 0. I realize that 0/0 is undefined, but, for our
purposes, we want to treat this is as 0. Is there some way to write an
expression that will return 0 in this case? In Access or Excel I could do
something like IIF(total transactions = 0, 0, total dollars/total
transactions). Is there some XPath equivatlent? Any help is appreciated.

Thanks,

Jay

 

[Franck Dauché]

Hi Jay,

You could do this with a textbox and some scripting or managed code behind.

Regards,

Franck Dauché