Need to figure out the formula in anaplan similar to excel

Aditya1993
Aditya1993
edited February 13 in Modeling
image.png

Formula for Final exploration drilling (Dryhole) in excel is -

image.png

Basically IF the first line items current year value is <>0 then then sum all the previous year and if the sum of all the previous year is zero then bring the data from other module.

Question is - How to look up all the previous year?? for example if the year is 2028 then the formula should sum all the value from 2024 to 2027.

Tagged:

Answers

  • Dikshant
    Dikshant

    You can enable the summary as SUM and take the values from top level using SELECT and then check if it's not equal to zero. Can you share a screenshot of the whole Excel file so we can see how the module looks like and how is the calculation performs in excel.

  • rob_marshall
    rob_marshall

    @Dikshant

    Try using Yearvalue() instead of Select for maintenance reasons.

Categories