Formula for "Actuals into Forecast": IF( POSITION("Time","Month List",ELEMENT("Time")) < POSITION("Time","Month List",VARIABLE("Time.Current Month")) , ["Actual"] , CONTINUE) -------------------------------------------------------------- Initial Formula for "Price": SEQUENCE("Time", "Month List", -1, ["Price"]) -------------------------------------------------------------- Final Formula for "Price": IF(["Price Override"]=0, SEQUENCE("Time", "Month List", -1, ["Price"]), ["Price Override"]) -------------------------------------------------------------- Formula for "Cost Price": IF(["Cost Price Override"]=0, SEQUENCE("Time", "Month List", -1, ["Cost Price"]), ["Cost Price Override"]) --------------------------------------------------------------