Summary >>> GetSummary result not showing as negative in portal as it should
I've a range of numerical data I'm working with that eventually ends up in a filtered portal. Many of the values involved are negative on the source data.
First, I use Summary on the relevant data and then to get to an annual figure I'm using GetSummary(SummaryField;Year)
All of the maths which takes place on the source table looks to be correct insofar as the final figure I want is what is being arrive at.
However, I have a couple of Summary>>>GetSummary results which are somewhere losing their negativity.
I've formatted the field to show the values as currency with £-1234 as the set up, so why are the values not appearing as such?