Recreating Excel Formula in Anaplpan

neg177
Regular Contributor

Recreating Excel Formula in Anaplpan

Hi, 

 

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))

 

Anaplan Formula: 

neg177_0-1633563129853.png

 

 

 

Thank you 

1 REPLY 1
KirillKuznetsov
Certified Master Anaplanner

Re: Recreating Excel Formula in Anaplpan

@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.