Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you thought about using a class function?
I try but my problem is i don´t have a fisical field. I want to create class function with calculated value or create a new field.
Like this, Field1=sum(Unit_base_demand*PrecoSimu2)
It´s possible?
Tanks
I believe it is, you can use a calculated field to be within your class function.
=Class(yourExpression, Interval, InBetweenLabel)
HTH
Best,
Sunny