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 am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in aβ¦
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import errorβ¦
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just Aβ¦
