02-10-2023
09:56 AM
- last edited
a week ago
by
JackLacava
Hello All,
Looking for a way to supress rows where there is 0s (drilldown has some +/- which nets to zeor for the row in CV). I have supression on and it works for the rows where there is no data and 0 as expcted. now in my below screnshot you can see whole rows seems like it is 0s or No data. there are few columns where it will be net 0 but has data on detial level. is there a way to supress these rows somehow? Looking for a an example or some pointers to explore the solution.
02-10-2023 10:17 AM - edited 02-10-2023 10:17 AM
Can you post your suppression settings please?
02-10-2023 10:29 AM
Row settings:
Column settings:
02-10-2023 10:33 AM - edited 02-10-2023 10:34 AM
Have you tried setting the Zero suppression threshold to an explicit value (0)? Does that help? Are you sure that zero is not a rounded value, in which case you need a higher threshold (like 0.5)?
02-10-2023 11:06 AM
Tankhs will try. Will that suppress numbers below zero ?