Need to figure out the formula in anaplan similar to excel
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.