doubt about expression!

[#1]

Hi, modeling the data i did this

I'd like to see in bonificaciones% only one expresion. this will be gross_sales + bonificaciones_nc + otras_bonificaciones / bonificaciones_prov

do you think i can do this?

regards

[#2]

I do not see why you would not be able to do this

Suggestion - do in the load script and so you do not have to claculate each time the user selects anything.

Make sure each item in the calcualtion is a dimension, which it sounds like it is, and I do not see it as an issue

[#3]

Hi thank you for your answer.

Because of the model, i'd like to sum this in the expression.

What expression do you suggest?

Regards,

[Kushal_Chawda]

try below expression

(sum(gross_sales) + sum(bonificaciones_nc) + sum(otras_bonificaciones)) /sum( bonificaciones_prov)

[#5]

These aren't expressions. They're dimmensions. The only expression is SUM(VALOR)

Greetings.

[#6]

I agree with Kush141087, not sure I understand your comment 'These aren't expressions. They're dimmensions. The only expression is SUM(VALOR)'