Recreating Excel Formula in Anaplpan

neg177
neg177
in Modeling

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 

Tagged:

Answers

  • KirillKuznetsov
    KirillKuznetsov

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

Categories