Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
rangemin(
sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])
,
0)
Would make all +ve numbers 0.
Hi Steven,
Thanks for the suggestion - it works very well. The only thing it doesn't do is remove the points which are not negative, which would be a lot clearer from a visual point of view. Is this possible?
Cheers
Neil
Hi Neil,
Try Using the below expression, with supress null values.
IF (
rangemin(
sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])
,
0) =0, null()
,
rangemin(
sum({$ <Period-={""},SummaryType={"Budget"}>} [Amount]) - sum({$ <Period-={""}, SummaryType={"Actual"}>} [Amount])
,
0)
)