If then formula for up and down arrow

[Anonymous]

Hello,

I have a formula that is based on the $ amount, the arrow should either be pointing up (for $ greater than 0) and down for $ less than 0.

I named the $ amount as a variable (KPI1) which is the current months $ amount - last months $ amount.

The formula I have is: =if(KPI1>0,'▲','▼')

Result:  

It should have the arrow going down. If someone could help me with the formula it would be appreciate.

[Digvijay_Singh]

Looks like KPI1 is not properly evalulated. Can you share the expression used for KPI1? If KPI1 is a value field then try Sum(KPI1) or any aggregation function you have used to calculate the value

[Anonymous]

Here is the KPI1 Formula:

Num(Sum( {$<_M = {$(=Max({<Month=,Facility=, Quarter=, [Responding Provider]=, [Queried Provider]=>} _M))},Month=,Facility=, Quarter=, [Responding Provider]=, [Queried Provider]=>} [Query Financial Impact])
- Sum( {$<_M = {$(=Max({<Month=,Facility=, Quarter=, [Responding Provider]=, [Queried Provider]=>} _M)-1)},Month=,Facility=, Quarter=, [Responding Provider]=, [Queried Provider]=>} [Query Financial Impact]),'$#,##0.00') 

[Digvijay_Singh · Accepted solution]

May be this -

=if($(KPI1)>0,'▲','▼')

[Anonymous]

That worked! Thank you so much!