Hi All,
I have a report and data like this
Brand : a
Category:C1
time sales
6 455
7 434
8 767
Brand : a
Category:C2
time sales
6 0
7 0
8 0
Brand : b
Category:C1
time sales
6 45
7 43
8 76
Like sales I have many numeric figues. I want to suppress categories data if all measure values are 0 only.If any one is non 0 I have to show that category values with all times.
As per attachment I want to hide these 2 categories
Hi Divya,
I hope you have a group on the 'Category' field.
Try this please:
1) Create a formula called (@zeroes) with this code:
If {numeric field1} = 0 AND {numeric field2} = 0 AND {numeric field3} = 0 AND {numeric field4} = 0 then 0 else 1
2) Go to the Group Selection Formula (Report > Selection Formulas > Group) and use this code:
Sum({@Zeroes}, {Category}) > 0
-Abhilash
Hi Divya,
You can even directly filter these records through record selection by giving following formula :
{firld1}+{firld2}+{firld3}+{firld4} <> 0
This will sum up your fields and check if it is zero or not. If zero it will not display else will display that record.
-Sastry
Add a comment