3 Replies Latest reply: Jun 4, 2015 6:04 AM by madhu mitha RSS

    Display only negative values on a map

    Neil Deeley

      Hi there,

       

      I've created a finance app. In the world of finance negative values display variance away from a set point (usually 0), so show values that are actually over budget. That's finance for you...

       

      I'm showing variance to budget for sites in a point map using this set analysis. How do i display only the negative points, and remove the positive ones?

       

      sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])

       

      Thanks in advance!

      Neil