Restriction line item based on another line item

HI all,

I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 the Values in Fnem01 is Values are not getting erased.

How can i fix this?

Capture_150593.PNG

Accepted answers

All comments

ManjunathKN

Hi @143kishornaidu

It is a junk value now, it will change only once you have another item there, if you want to be blank in target after the deletion, you should have a mechanism to import blank into that cell(you can achieve that by an blank import).

Thanks,
Manjunath

143kishornaidu

What is mean by mechanism,

How can i create it

ManjunathKN

@143kishornaidu

I meant action to import 0 values. but have you tried this logic, if isnotblank(Account) and isnotblank(Program) then values else 0

Thanks,
Manjunath

143kishornaidu

Treid

ManjunathKN

@143kishornaidu

It is difficult to tell just by looking at the circular ref.

It is causing because your expense line item is already driven from those program and account line item.

Try to create 2 line items and refer program and account line item(I am trying to break the source from loop, which causing the Cir ref) and now use these line items for isnotblank logic instead of original ones.

Thanks,
Manjunath

ManjunathKN

@143kishornaidu

you are using expense in the expense line item, it will certainly throw error. please use the logic used in Expense line item.

Lets say, Expense = Module A.Line item

the use the logic Expense = If isnotblank(product) and Isnotblank(account) then Module A.Line item else 0.

Thanks

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…