Applying different formulas to list

Hi, i'd like to ask about how to apply different formulas on each item in a list.

As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline column is from the previous month actual data, while the Growth % and Growth column is an input column for expected growth for the following month. Could you please give the solution since as far i know, a list is only able to capture the same formula for each of its item. Thank you.

Module 1 and Blueprint Views

Module 1.PNG

Module 2 and Blueprint Views

Module 2.PNG

Accepted answers

All comments

ShubhamCh

Hi @aurellionugroho

Are Baseline, Growth, Growth%, Final list items?? I am confused looking at the pictures. Please share the blueprint view as well and also some more details related to your end goal.

One tip:- Paste pictures in descriptions because it is easier to look and scroll back and forth when the pictures are in the description.

Thanks!

-Shubham

ManjunathKN

Hi @aurellionugroho ,

Anaplan is designed to work in that way, to have single formula across all list items.

However, you can have different formulas for different list items in a single line item. This can be achieved by System boolean module and IF THEN ELSE logic.

You can also group set of list items in your system module with logics, if set of your list items needs to have similar formulas. This will help you to reduce the number of iterations in IF ELSE. (This is band/range based calculation)

This is tedious process when if else iteration seems to go quite high if more number of list items require different logics.

Other way is to create LISS from that list, bring data from collect and create few line items for different set of calculations. This might not be your case, also check if this helps.

Thanks,

Manjunath

aurellionugroho

Hi @ShubhamCh

Yes, Baseline, Growth, Growth%, Final are list item. I've also updated the picture to ease you understand my context. Will really appreciate your help. Thank you.

aurellionugroho

Hi @ManjunathKN

Thank you for your input. Will be considering which one suits best to my case.

ShubhamCh

Hi @aurellionugroho

The structure of the modules seem very odd to me because in the module1 you have Cash Flow list, while in the second module I see line items with the names of Cash Flow list items.

Why did you not apply Cashflow list in module 2 as well?

If Baseline, Growth, Growth%, Final become line items instead of list items, the solution will become much easier.

Thanks!

- Shubham

Quick Links

Can you help?

Unanswered questions

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…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…