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,
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?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showingβ¦