7 Replies Latest reply: Mar 10, 2016 3:20 AM by PAUL YEO RSS

    How can i avoid If in my expression in case i need to make the eXP chart show in +ve ?

    PAUL YEO

      Hi All

       

      This is my org expression , the issue is when user click on eXP , the value will display in -ve Bar , which look funny :-

       

       

      money(

      (

      Sum({<$(ColumnDim51)={$(ColumnDim51)}>}Amount)/$(Columndim89)/1000

      )

      , $(vMoneyFormatK))

       

       

      After change the above expression to below , i manage to make eXP display on +ve .

       

       

      if

      (

      match([Pls select 66 Dim],'rEVENUE'),

      money(

      Sum({<$(ColumnDim51)={$(ColumnDim51)}>}Amount)/$(Columndim89)/1000,

      $(vMoneyFormatK)),

       

       

      if

      (

      match([Pls select 66 Dim],'sales'),

      money(

      Sum({<$(ColumnDim51)={$(ColumnDim51)}>}Amount)/$(Columndim89)/1000,

      $(vMoneyFormatK)),

       

       

      if

      (

      match([Pls select 66 Dim],'eXP'),

      money(

      Sum({<$(ColumnDim51)={$(ColumnDim51)}>}Amount)/$(Columndim89)*-1/1000,

      $(vMoneyFormatK)),

       

       

      if

      (

      match([Pls select 66 Dim],'n_PRO'),

      money(

      Sum({<$(ColumnDim51)={$(ColumnDim51)}>}Amount)/$(Columndim89)/1000,

      $(vMoneyFormatK)),

       

       

       

       

      ))))

       

       

      My question is , it there more simple solution ?

      Can i avoid  using the if ?

      One more question is for long expression like above , it will affect the performance , i mean create slow display of result.

       

      I will post my QV example in next posting.

       

      Paul