0 Replies Latest reply on Feb 4, 2015 4:36 AM by Stu412

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

    Stu412

      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