1 of 1 people found this helpful
IFNULL(sales, previous value(0))
Thank you I'll let you know how it goes. I tried to make it much more complicated.
Hi so this won't work for me because the sales apparently need to be aggregated which i cant have happen.
It wants this : IFNULL(SUM(sales), previous value(0))
and I need it to not do that.
First change the default properties for the fiscal year, Then try this
IFNULL(sales, (if DATEPART('month',[Order date]) = (DATEPART('month',DATE(TODAY()))-1) THEN [Sales] END))