Hiding null values in a column in SAP Crystal Reports
In SAP Crystal Reports, I have to show some of the numerical values of a column and if the sum is coming 0. I want to hide that.
I have written below formula however it still shows ‘0’ value:
* IIF ( ToNumber({Choice_.Choice1}) > 0 , true, false) >> Gives Count. Need Sum
* NOT(ISNULL({Choice_.Choice1}))
* IF( ToNumber({Choice_.Choice1}) > 0) then ToNumber({Choice_.Choice1})