How to display if amount is Zero then need to be displayed zero value
Summary:
How to display if amount is #ZERO then need to be displayed zero value.
Content (please ensure you mask any confidential information):
I need to make 'IF(K6=0,0,IF(-K6<A6-D6-J,-K6,A6-D6-J6))' formula in FRS report.
I am splitting this formula into two parts.
1. K6=0,0,
2. IF(-K6<A6-D6-J,-K6,A6-D6-J6)
Part2 we have handled by using following formula in FRS report-
IfThen(IsErr([K]),0,IfThen(IsMiss([K]),0,IfThen(IfNN([K]),0,IfThen([O]<[P],[O],[P]))))
But we are not able to make condition for part1.
The challenge here is K actual is not '0' it is '#ZERO'. I did not see any function provided to handled '#ZERO' where as we have for '#ERROR' and '#MISSING'
Tagged:
0