Formula Calculation

TLam99
Occasional Contributor

Formula Calculation

I am writing calculation formula which I am struggle a little, hoping anyone can help me out.

 

When writing calculation formula in Excel, we can use ( ) to group the calculation together, but Anaplan does not work the same way or am I work? Is there a way to group calculation together within Anaplan?

 

Thanks in advance,

1 ACCEPTED SOLUTION

Accepted Solutions
MarkWarren
Expert

You can use parenthesis around formula and mathematical terms, Anaplan will automatically remove them if they are not needed though.
ex. (A + B) > (D + E) would be shown as A + B > C + D
whereas (A + B) / (C + D) would keep the parenthesis.

View solution in original post

2 REPLIES 2
MarkWarren
Expert

You can use parenthesis around formula and mathematical terms, Anaplan will automatically remove them if they are not needed though.
ex. (A + B) > (D + E) would be shown as A + B > C + D
whereas (A + B) / (C + D) would keep the parenthesis.
TLam99
Occasional Contributor

Thank you Mark