How to find maximum value of cube or entity in Layout Editor?

Ilham Maulana Habibie

Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview :

"Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month"

I will appreciate your helps for this case.

Thanks.

Helmut Heimann

Hi @Ilham Maulana Habibie ,

That depends on how your layout should look. Would you like to display the months on the x-axis (i.e., from left to right) or on the y-axis (top to bottom)?

The Nexel will likely be the best way to calculate the values.

You can find an example on how to calculate the current month in Nexel here in our how-to section

https://community.board.com/discussion/17840/how-to-use-nexel-to-select-custom-time-periods

The next step would be to only use the values for the current month and then apply Nexel's max() function.

Best,
Helmut