2 Replies Latest reply: Feb 10, 2016 6:10 PM by PAUL YEO RSS

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

    PAUL YEO

      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