Need to figure out the formula in anaplan similar to excel

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

    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
    Options

    @Dikshant

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

Categories