You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register


Accepted answer
edited Mar 8, 2021 6:01PM in Narrative Reporting 6 comments



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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!