Skip to Content
0
Jan 16, 2019 at 04:28 PM

Crystal Reports 13: Need help Writing a Conditional Formula

240 Views Last edit Jan 16, 2019 at 08:42 PM 2 rev

Hello,

I'm attempting to write a conditional formula. I'm trying to compare two numbers. A top number and a bottom number.

If the bottom number is 0 and the top number is less than or equal to 0 then display the result 'N' for NO else Y.

Top Number = Sum of @total std (Number)

Bottom Number = Sum of @total actual (Number)

So for example have a top number of 2,400,00000 and a bottom number of 0.00000 then I want to display 'N' for No. If the conditions are not met in the formula then I want it to display 'Y' for Yes.

If both numbers are equal to Zero then I want it to display 'N' as well. So anytime the top number is less than or equal to zero then I want to display the result at 'N" else 'Y'

Thanks!