Skip to Content
0
Former Member
Jun 16, 2014 at 05:33 PM

How to prevent 0 from showing after export to Excel?

13 Views

This is the formula and I'm currently suppressing the 0 in crystal but when I export it excel the 0 shows up again.

//Check if supply used

if isnull({OR_PKLST_SUP_LIST.SUPPLIES_USED}) then 0 else

{OR_PKLST_SUP_LIST.SUPPLIES_USED}