Hi, I need to use the same 6-month average calculated estimate to the consecutive months until I receive a new invoice number for that month. Ultimate goal is to have estimate for every month even though we don't have invoice for the previous month.
I have already implemented multi-row formula to calculate 6-month average which calculates estimates. but I need to use the same same estimates for coming months until i receive a new invoice.
I've used this formula, but nothing pops on the estimate field.
if isnull([invoice]) then (
if [estimate] !IsNull then [estimate]
else [Row-1:estimate] endif)
else [estimate] endif
Attached screenshot:
Solved! Go to Solution.
Hey @Ronal_bal you've just slightly mistyped your formula
if isnull([invoice]) then (
if !IsNull([Estimate]) then [estimate]
else [Row-1:estimate] endif)
else [estimate] endif
Your !IsNull() needs to wrap around estimate, then it works :)