How to put formula in one list item and keep blank in the other

Given that we set a list which has two items of A and B as a dimension of a module,

we would like to put formula in a list item A. On the other hand, we want to keep blank in a list item B so that end users can input data.

How can we implement this?

Regards,

Maki Yasuda

Accepted answers

All comments

Kyle

Hi Maki,

There is no way to have a line item be editable for some situations and be a formula for others except using formula scope which relies on version. For a list, you would have to have multiple line items where one would be an input and then another that has a formula that for Item A does what you would like it to, and for Item B, grabs the value from the first line item. You can use the ITEM function to help with specifying which items are applicable for different parts of the formula. I hope this helps!

Best,

Kyle

myasuda

Hi Kyle,

Thank you for your answer and sorry for my delayed reply.

After all, I decided to prepare two line items. One is for user input and the other is in which fomula is input.

Best regards,

Maki Yasuda

Quick Links

Can you help?

Unanswered questions

ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
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…