3 Replies Latest reply: Apr 7, 2015 4:48 PM by Sunny Talwar RSS

    Create interval in dimension calculate

    Pedro Lopes

      Hi all,

       

      I need some help with this calculate dimension.

       

      =if(sum(Unit_base_demand*PrecoSimu2)>50,Dual('>50',1),if(sum(Unit_base_demand*PrecoSimu2)>100,Dual('>100',2),if(sum(Unit_base_demand*PrecoSimu2)>150,Dual('>150',3),Dual('>200',4))))

       

      I need to create a calculate dimension with sales value at intervals.

       

      I need to turn 'sum(Unit_base_demand*PrecoSimu2)' on the field??

       

      Tanks in advance,

       

      Pedro Lopes