Question Re: how to aggregate on Year node/level in Technology Q&A

how to aggregate on Year node/level

LaurentS — Thu, 12 May 2022 10:26:39 GMT

Hello,

We would like to create an input schedule with a calculation on a ratio and calculate it at Year level.

Unfortunately all ratio are calculated for each month then summed up.

We would like to sum up for all 12 months then calculate the ratio for the year.

Any idea?

Thanks in advance.

Laurent

Re: how to aggregate on Year node/level

Sowmiya_C — Thu, 12 May 2022 13:35:05 GMT

Hi,

Can you explain your scenario with an example ,so that we can understand easily.

Thanks,

Re: how to aggregate on Year node/level

Jay_Gandhi — Thu, 12 May 2022 19:46:16 GMT

Hi there,

Depending on your specific use case and dimensions used you could create a calculated measure to do so.

For example you could turn on exception aggregation for your 'base' measure to calculate the appropriate values by month and then an aggregated measure which sums these base measures to create the correct value at the node/year level.

Jay