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

    Synthetic dimension functions - Valuelist

      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