Trying to replicate this same Excel Formula in Anaplan, but leads into a Circular Reference. Please advise on how would do so. The Excel Formula and the Formula we are attempting to us in Anaplan are below.
Excel Formula: =IF(AND(AJ31=0,AK31=0),AJ103*AK$71,IF(ISBLANK(AK31),AJ31*AK$71,AK31))
@neg177try to go through your references in the formula.
Seems like at least one of your objects in the formula is referencing to a line item which uses this line item in it's calculation.