Dynamic chart-2 Time line

Hi!

I have 2 line items:

1. Actual revenue, data for the period: from jan19 to Sep 19

2. Budget revenue, data for the period: from sep19 to dec19

I need to build a chart, that will have one actual graph from Jan to Sep and another plan from Sep to Dec

The problem is that Anaplan uses values (which are zero) for the budget Revenue from Jan19 to Aug19 in the chart (Actual revenue line not uses zero values in the chart after Sep 19)

The result required is in the attachment (Blue Line)

Doc1_54289.docx

Accepted answers

All comments

Misbah

@Vladimir

Not sure if I understood your requirement correctly. Is your requirement to generate two line graphs for two key figures (Budget & Actual) and Not taking Budgeted Zeroes into consideration while populating the line item chart for Prior Months.

Isn't there any number sitting in Budgeted cells for prior months?

Misbah

a.dilieto

Hi @Vladimir ,

you could create a third line item "Actual & Budget Revenue" that takes "Actual revenue" for the closed months and "Budget revenue" for the open months and create a line chart with "Actual & Budget Revenue" and "Actual revenue" (in this order to have visible the split between closed and open periods in the graph).

You should have a result similar to the example attached.

Forecast&Actual.JPG

Regards,

Antonio

Vladimir

Hi Antonio!

The point is that there should be an overlap for the last month of the actual and first month of the budget.

The last month of the actuals is Sep 19 and the first month of the budget is also Sep 19.

That is why I created 2 Line items

Thank you.

Vladimir

Hi @Misbah !

Yes, you got the point! I need to create two graphs not taking into consideration any zero values.

There are no values for the budget prior month.

See the attachment, how the data is looking like.

Thank you.

Data_54301.xls

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…