Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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,
try below expression
(sum(gross_sales) + sum(bonificaciones_nc) + sum(otras_bonificaciones)) /sum( bonificaciones_prov)
These aren't expressions. They're dimmensions. The only expression is SUM(VALOR)
Greetings.
I agree with Kush141087, not sure I understand your comment 'These aren't expressions. They're dimmensions. The only expression is SUM(VALOR)'