Create interval in dimension calculate

[Anonymous]

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

[sunny_talwar]

Have you thought about using a class function?

Class function‌

[Anonymous]

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

[sunny_talwar]

I believe it is, you can use a calculated field to be within your class function.

=Class(yourExpression, Interval, InBetweenLabel)

HTH

Best,

Sunny