Suppression

Content

Hello!

I spending a lot of time on this, without finding a good solution.
In my reports, the numbers must be /1000 and if I use "Scale Value By thousands" in "Number" properties, sometimes occurs that the total sum of the lines doesn't match with the numbers in the lines.

So I had to add additional formula columns to round and /1000 manually (Round(Eval([A]/1000),0) and then make a simple calc in the first line of the table to prevent the wrong sum in the total.

But when I need to suppress lines with 0, just not happens because my two first columns (colored and hidden) that not divide /1000 has numbers, even those columns hidden doesn't work.