Ratio Summary - Line item & time.

ManjunathKN

Hello Team,

I was wondering that can we have different ratio for line items and time. For ratio as summary in Anaplan we have only one option, which will calculate the same for both line items and Time.

Any suggestions, can we have different summaries by any work around. 

Thanks,
Manjunath

shreyashree

Hi @ManjunathKN 

I am not sure about the use case to which you are trying to apply this solution. 

But I could achieve this using two additional line items (Numerator and Denominator) in which you will calculate the expected values based on condition which checks if it is time summary or non-time summary. This will be a little confusing, so please bear with me. 

1. This is the data which I will be using as numerator and denominator of the ratio summary based on Time and Non-Time (Other) dimension.

2. The logic to determine Time and Non-time dimension is as follows:

This is how it looks like in the module - Time checked in the time summaries and Other checked in Non-time summaries:

3. Then create the Numerator and Denominator line items with Formula summary which are calculated based on the above booleans.

4. Set the Numerator and Denominator line items in the Ratio summary.

The highlighted values show the ratio summary calculated.

Let me know if this works for your question. Thanks.