Formula for Summary

I have a case, i want Monthly Amortization Line item can show Quater amount. but not show because on Summary have Sum,Time:Formula. Can give me a answer. Thank you. Help me

Accepted answers

Panji

Hi,

I think maybe in your source module you using closing balance, so it will make you Q1 amount will 0.

you can change closing balance to another format.

Thanks

All comments

Tiffany.Rice

This would suggest that the source for the 2020 data does not have quarterly totals enabled (no time sum). When using the summary method of Formula, the target module does not calculate the sum but rather references another module/line item for that value.

Muh_Arief

So do you have any idea ? I am very confused about that.

Tiffany.Rice

If the formula references another module, then you will need to ensure that the quarterly totals are reflecting there correctly. Can share the formula on the line item in question? It's difficult to determine the root issue just looking at the values alone.

Muh_Arief

this formula for final report: * time filter. **bleep** count for calculation Quarter, Q1: 3, Q2: 6, Q:9

this formula for **bleep**. count

Panji

Hi,

I think maybe in your source module you using closing balance, so it will make you Q1 amount will 0.

you can change closing balance to another format.

Thanks

ChrisAHeathcote

Hi,
I think the best approach is to spread this out over multiple line items.
The Quarterly summary is cumulative while the months are not and this is causing you the issues.
Create the following line items -
1. Monthly
2. Monthly Cumulate

3. Cumulate reset
4. Ref

1. Monthly will house you monthly movement
2. Monthly cumulate will be the cumulative of the 1.Monthly, set summary to SUM, formula = CUMULATE( 1.Monthly, 3. Cumulate reset )
3. Cumulate reset, boolean format and time set to Quarters, formula = true
4. Will contain a formula = 1, set summary to formula

In line item 1. Monthly set your summary to ratio - 2. Monthly Cumulate / 3. Ref
This will result in the your months showing the monthly movement and the quarters to cumulative for that quarter.

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…