Hi all,
I have a pivot and a calculated field that if the sum is greater than 0 shows 0 and if not shows the shortage (negative value). This field is calculating correctly in each row of the pivot (showing only negatives) but is showing 0 in the subtotal row when it should be a negative value.... feeling confused.
Bookmarks