3 Replies Latest reply: Jun 4, 2015 6:04 AM by Madhumitha C 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!