Aggregate formula

Question

Summary

Aggregate formula

Content

Hi  all,

I am not sure what i do wrong using aggregate at formula. Perhaps i do not understand its purpose.

if I enter Total revenue as a measure into the formula below and product family as dimension, i get an error.

How can i enter this calculation correctly?

Regards

Adam Bloom-Oracle · Answer

If you want to control aggregation, we recommend use of “aggregation method” in the viz properties.  While calcs can be used, the viz properties are the recommended approach.

Jose Casquero · Answer

Good links,   I will keep it for future.

Jose Casquero · Answer

Thanks Adam

You advice fixes the problem.

However, i am trying to make to work  the aggregate function located in the calculation console but i can not figure out why it does work