Crosstab & DetailArea & Percent & null/zero

I am trying to compute the percent in the DetailArea of a CrossTab.

When the Numerator/Denominator are null/zero I get a ?1? in the column if I use Finance.percent(D,N,1). if I do the math myself I get ?NaN?. I tried: if (measure["MY_VALUE2"] != 0) { then compute it } ... no luck.

Question is: there a way to compute percentage in the DetailArea of a Crosstab and handle (do not compute/display) the value when the Numerator/Denominator are null/zero?

Thanks in advance.

Find more posts tagged with

Comments

mwilliams

Hi buckethead,

Can you attach your report design? Do you happen to have an example of this problem created using the sample database or a flat file database so that I would be able to run it? If you do, or could create one, that would be the easiest way for me to take a look because of the ability to do testing. If not, attaching your report design may still help. Thanks.