formula summary

143kishornaidu

HI All,

Why we use summary as formula.

what are the scenarios that we use this ?

what is the outcome of it?

Accepted answers

All comments

ManjunathKN

Hi @143kishornaidu,

In simple words, When you use a formula logic in formula bar, you need to use formula as summary.

Below table should explain you.

Thanks,
Manjunath

medaganeshamanikanta

Hi @143kishornaidu

As @ManjunathKN was mentioning that we use formula as summary method, when there is formula present in the formula bar.

By doing this what happens is, the formula would also be applied to the summary items. Like in the example given by @ManjunathKN for Q1 which is a summary of Jan, Feb, Mar, the formula(Line Item A/Line Item is applied for Q1 also i.e 60/90=0.66.

Whereas in the other case the summary enabled as sum and it is just adding the result of Jan, Feb, Mar in the Line Item C (0.5+0.66+0.75=1.91)

Hope this helps

Thanks

Meda Ganesha Manikanta

Matasma Digital Technologies

Quick Links

Can you help?

Unanswered questions

Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.
Is there a way to auto-generate ID for user who entered line item?
In the UX, I want to be able to filter list members so end users can only see the list members they created/added. The users in this situation all have WSA access as this is a UX for our internal Anaplan team. These list members are currently being added by the form action in UX and I would like to avoid the user having to…