HI All,
Why we use summary as formula.
what are the scenarios that we use this ?
what is the outcome of it?
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
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
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
