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