Need to figure out the formula in anaplan similar to excel

edited February 13 in Modeling

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

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.


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

  • @Dikshant

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