Circular Reference Issue
I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand.
This is the driver module and this is already working fine in Anaplan. Lets say Row 1 and Row 2 and then Time Dimension.
This is the countif module, this also working fine in Anaplan.
This is the Target Module. This is where the Circular reference is appearing.
The formula here is IF Driver Module Row 1<=0 THEN Countif Module ELSE Countif Row 1+ Driver Module Row 2
the logic here is when Driver Module Row 1 is valued at 0 then it should capture Countif Module Row 1 and if Driver Module Row 1 is more than 0 then it should capture Driver Module Row 2. This part of the formula has no problem IF Driver Module Row 1<=0 THEN Countif Module ELSE Countif Row 1 but when I add + Driver Module Row 2 in the formula that is where the circular reference comes up.
Any idea? Thank you in advance.