When i select Diamension = eXP . How to make my Table display +ve value ?

[paulyeo11]

Hi All

When i select Diamension = eXP . My Table display -ve value.

I need to make the YTD Variance display +ve value ?

Because Expense is lesser for 2015 , meaning it is good , so it should be +5% and green color

In other work , when i change the diamension = eXP , i need to make the value display as +ve.

My imagine expression as below :-

=IF([[Pls select 66 Dim]] = 'eXP',

(

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/1000

*-1)

But it does not work.

My next post i will post my QV sample doc.

Paul

[MK_QSL · Accepted solution]

Use below in background color expression

IF([YTD Variance] > 0.05, Green(),Red())

[paulyeo11]

Hi sir

Thank you for your script.

Great I think I know how to modify your script to suit my need .

As I need to add on condition for eXP.

Paul

Sent from my iPhone