I have a report in custom mode, where I’m calculating a variance %. Everything works great until I sort descending, I end up with 0’s then negatives then anything greater than 0. Is there anyway around that?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Custom Mode breaks variance percentage? | 2 | 879 | February 28, 2023 | |
| Calculated Measure Error | 1 | 1009 | November 12, 2019 | |
| Only Sorting Returns | 1 | 733 | March 24, 2022 | |
| Summary Chart Colors Based on %Variance | 1 | 589 | March 6, 2023 | |
| Sort using one measure but create chart displaying another measure | 0 | 184 | February 23, 2024 |