3 Replies Latest reply: Jun 4, 2015 6:04 AM by Madhumitha C

# Display only negative values on a map

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])

Neil

• ###### Re: Display only negative values on a map

rangemin(

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

,

0)

Would make all +ve numbers 0.

• ###### Re: Display only negative values on a map

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

• ###### Re: Display only negative values on a map

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)

)