Hi,
I want a add 3 data items in my crosstab. But one of the Dataitem value contains 'NA' character. If I add those 3 dataitems, i'm getting the result as 'NA'.
I've used the Exp as DataItem1+DataItem2+DataItem3
How do I get the total value? (10+NA+8=18). But I'm geting the result as NA.
The solution would depend on the origin of the 'NA'. Why are 'NA' (Not Available) values returned? If you can fix this in the query that fetches the data and make sure a zero is returned instead, then the addition would be okay without additional work..
You can format that data item N/A as '0' and then u can add all the data items