0 Replies Latest reply: Dec 7, 2011 1:54 AM by Byron Van Wyk RSS

    Synthetic dimension functions - Valuelist

    Byron Van Wyk

      Hi Guys,

       

      I wanted to try and use valuelist inside an aggr if function...this didnt work. My expression looked like this

       

      Aggr(if(CostCentreType='Operations',Valuelist('Revenue','Cost of Sales','Margin','Margin %'),Valuelist('EBIT')),CostCentreType)

       


      What I am trying to achieve is that if CostCentreType (It has been added as a dimension) is 'Operations', then use the first valuelist, if CostCentreType is something else use the 2nd Valuelist which is just 'EBIT'

       

      Any idea how to get this to work and where I am going wrong

       


      Cheers,
      Byron