Using multi row formula

[Ronal_bal]

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:

[OllieClarke · Accepted 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 :)