Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use below in background color expression
IF([YTD Variance] > 0.05, Green(),Red())
Use below in background color expression
IF([YTD Variance] > 0.05, Green(),Red())
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