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

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…