Stemiller

Comments

I combined your formulas and changed them slightly and it worked for me. Thank you so much! max(CASE when Date = (Current_Date())-1 then Inventory On Hand when (Date+ DateDiff(Date,Max Date)) = Max Date then Inventory On Hand end) @MichelleH

in Showing some values based on SUM, other values based on the most recent date available for the week? Comment by Stemiller April 2023