Replace Nulls with the previous Value

[RichardLee]

I have a pivot table and I would like to replace the Null Value with the previous Values.

This should go from Jan 2018 all the way to Current Date

the mesure is a very simple Sum([Total Costs £])/Sum([MapSrcHeads.Order Qty])

[BrunPierre]

=If(isnull(Sum([Total Costs £])/Sum([MapSrcHeads.Order Qty]),Above(Sum([Total Costs £])/Sum([MapSrcHeads.Order Qty]),1),Sum([Total Costs £])/Sum([MapSrcHeads.Order Qty]))

[RichardLee]

This wouldn't work. "isnull" only allows one parameter and with the divide that makes two.