Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to sum the values from the start of the current week to a variabe date in the future that has values. If I put a specific date in the future, I get a return value. If I try to take todays date and add 7 or 14 to it or a variavbe input, I get nothing returned.
=sum({$<Gross_Forecast_Week = {">=(weekstart(Today())<=(weekstart(Today()+ vWeeks)"}, Gross_File_Week={'$(=Max(weekstart(Gross_File_Week)))'}>} Gross_Forecast_Quantity/(8*4) )
Probably the numeric format is the problem...
Could you send the app?