0

Have field remain blank if sum is zero

Hello, this is probably something simple that I'm missing, but...

 

I have two number fields in a table that I are added together to make a total. If this total is zero - as in £0 - then I would like the field to remain blank, rather than displaying the zero.

I have tried every way I can think of to do this, but I either lose all the values, or have a list of zeros, which makes my report look messy.

 

These are my fields that are added together:

'PO COST'

'SC COST'

 

Both are located in table 'Frameset'

 

Any help is much appreciated!

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    if 'PO COST' + 'SC COST' then 'PO COST' + 'SC COST' end

    Steven

    • Anna_Wenlock
    • 3 yrs ago
    • Reported - view

    THANK YOU! That was driving me mad!

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 196Views