AnsweredAssumed Answered

Summary >>> GetSummary result not showing as negative in portal as it should

Question asked by Stu412 on Feb 4, 2015

Title

Summary >>> GetSummary result not showing as negative in portal as it should

Post

Hi there

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?  

Thanks

 

Outcomes