Best Practices - Order of Operations on Formulas?

Highlighted
Occasional Contributor

Best Practices - Order of Operations on Formulas?

Reviewing my work vs the listed formula in the training, I find that I wrote a formula as:

 

'REV01 Price Book'.Unit Price * 'REV02 Volume Inputs'.Volumes

 

...but the documentation puts it as:

 

'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Price

 

My immediate reaction was "oh, it won't matter which order they're in - it's just multiplying..." but then I second guessed myself and went "Hmm, sometimes Anaplan has order of operations speed response issues...maybe it DOES matter which is read first..."

Is that the case here? Is there something based on wanting whichever module has the fewest cells to be first in the calculation or anything, like when we try to optimize an If/Then statement for fewest reads? My OOP trained brain says no, but...

 

Thanks,

-Rachel

 

 

2 REPLIES 2
Highlighted
Contributor

Re: Best Practices - Order of Operations on Formulas?

Hi Rachel, Nice query 🙂

 

I feel there is no such order of operations in Anaplan, until parenthesis is used. In remaining cases it is parallel execution.

 

Regards,

Basavaraj

Highlighted
New Contributor

Re: Best Practices - Order of Operations on Formulas?

Hi

    No Buddy we must follow some order to write formula....