Friday, February 08, 2013 3:05 AM
I need to get rid of the empty cell displayed of a group column as shown below. This happens if all rows in that column contains nothing or zero. I already put the necessary conditions like for instance IIF(SUM(Fields!Sales.Value) = Nothing OR SUM(Fields!Sales.Value) = 0, 0.0, SUM(Fields!Sales.value)) but to no avail.
As seen in the columns, it doesn't display 0 but a blank white spaces.
- Edited by Jayvee Santiago Friday, February 08, 2013 3:06 AM
Friday, February 08, 2013 9:47 PMtry: =IIf(IsNothing(SUM(Fields!Sales.Value)),0,SUM(Fields!Sales.Value))
Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
Monday, February 11, 2013 10:53 AMIt doesn't work as well.
Monday, February 11, 2013 11:21 AM
i see you AX subtotal shows 0.0 in green. So do you have an expression in the visibility part maybe? if not
can you try:
Please mark as answered or vote helpful if this post help resolved your issue. Thanks!
k r o o t z
Thursday, February 14, 2013 9:39 AMModerator