Formatting Question

Hi,

Is there a way to put in one Formula for Actuals and another Formula for Forcasting? I was thinking I might have to create two Line Items (one for Forecast and one for Actuals) and put those formulas into the separate line items? Is this thinking logic correct?

Thank you

Tags

Modeling

Accepted answers

Not sure what is your current day line item but you can use directly in the main line item.

IF ISACTUALVERSION() THEN module/condition for actual ELSE module/condition for forecast

I am assuming you are using number formatted line item then your formula should not use blank

For example

if isactualversion() then 0 else Back Book + Front Book

All comments

No need to create two line item one for actual & one for forecast, You can use ISACTUALVERSION() function to write the formula in one line

IF ISACTUALVERSION() THEN actual module.line item ELSE forecast module.line item

https://help.anaplan.com/en/31afd05f-0b36-4374-a7f2-60c1b10a504e-ISACTUALVERSION

hope this helps!

Thanks

Akhtar

Great, Thank you

What would go in as my Perameters for the ISACTUALVERSION() function? Would I put in my Boolean Line Actuals Line Item or my Current Day Line Item?

Not sure what is your current day line item but you can use directly in the main line item.

IF ISACTUALVERSION() THEN module/condition for actual ELSE module/condition for forecast

this is the formula I'm using for my Line Item...

if isactualversion() then blank else Back Book + Front Book

If it is a date in my Actuals then I want it to be blank (allow me to put in a value), anything else i want it to put in my Forecast Formula. It is saying that my data format doesn't match None or Number.

I am assuming you are using number formatted line item then your formula should not use blank

For example

if isactualversion() then 0 else Back Book + Front Book

This is meaning that I have to have a calculation for my Actuals and can not just input a number?

If you want to have a manual input for Actuals you can use the formula scope option in blueprint view for the line item. Set this to 'All Versions except Actual' and that way your formula will work for all forecast versions but the cells will be blue and editable for the actual version.

You won't need the ISACTUALVERSION() part of the furmula if you do this.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…