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!

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • RoSoft_Steven
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

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

    Steven

    Like
  • THANK YOU! That was driving me mad!

    Like
Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 187Views