Hi, Anaplan Community,
I have a question about the Waterfall Chart in the UX.I'd like to have the positive values start from 0 instead of the previous line item. I would appreciate your input/assistance.
Backend:
Hi @sosunkwo ,
It looks like the setup does not have formulas for sub-totals and totals. In this case, I believe Gross Margin should be derived from previous line items which will assign relationships to display the waterfall.
Please check if the below helps you:
β
Regards,
vinayvm
@Vinay VaradarajMplease can you elaborate.
Waterfall charts need summaries defined by way of formulas. Below is the same example with blueprint view:
Sub-total = sum of the first 4 line items
Total = Sub-total + copay + Other costs
By doing this, the system assigns parents and summaries to line items which help in displaying waterfall charts:
So effectively, you need to have sub-totals/totals line items which aggregate the underlying information to display waterfall chart. These columns for sub-totals/totals start from zero unlike the rest.
Hope this helps!
@Vinay VaradarajMWhere are your Net Demand & Gross Margin Line items?
Basically, the line items which you would want to start from zero should be your sub-totals/totals, which in this case are Net Demand and Gross Margin.
regards,
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.β¦
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β¦
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β¦
