Skip to Content
0
Jun 14, 2018 at 04:16 PM

How to use Sum which has value hyphen "-"

135 Views

Hello, I'm using following to display play hyphen "-" if the value is NULL

If isnull {Command} then ' -'

else

ToText ({command} ,1)

This works just fine,but I want to sum of that group and if the group has only one row which is null then that that value display blank instead I want it that as hyphen "-"

For example:

AAA

A111 -

Total AAA

BBB

B111 -

B112 10

Total BBB 10

As you can see from above example "Total AAA" show just blank instead I want it to display - (Hyphen) Any suggestion?

Thank you