> Dear Expert,
>
> I'm listing values in a report writer.
>
> However where the outcome of the value is negative, it should be replaced with a zero
>
> and the final total should treat the value as such.
>
> The value is based on the summation of 4 fields ie (allow1+allow2+allow3+allow4)
>
> If the summation of allow1+allow2+allow3+allow4 is negative the value in the report should be zero in the listing,
>
> and the group total should treat -ve values as zero in the summation.
>
> How do I treat this issue in the report writer?
>
>
> Thanks
use IIF(Allow1<0,0,allow1) whereever you have allow1. Same for the others.
Regards
Tushar