Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
=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]))
This wouldn't work. "isnull" only allows one parameter and with the divide that makes two.