This content has been marked as final.
Show 2 replies

1. Re: Percentage calculation with a filter but using the SUM of all entries
Scott Hoffman Feb 8, 2019 6:01 AM (in response to Dietmar Freitag)Dietmar,
This can be achieved using a Fixed LOD Calculation. First get the total using { FIXED : sum([Number])}. Then get the percentage by using [Number] / [Total LOD]. the filter does not impact the Fixed LOD so the percentage will stay.
See attached and let me know of any questions.
Thanks,
Scott

Region Number Lod.twbx 12.9 KB


2. Re: Percentage calculation with a filter but using the SUM of all entries
Dietmar Freitag Feb 8, 2019 6:14 AM (in response to Scott Hoffman)It works.
I knew, that there is a simple way.
Thanks
Dietmar