Comments
-
Thank you!! So helpful!
-
@jaeW_at_Onyx Thank you for this input. I did not use Magic because I am not simply trying to look for the most recent date - I am attempting to join two datasets together by date - Where a date exists in my left join and does not exist in my right join, I am coming up with null values. So what I was attempting to do was…
-
Thank you @MarkSnodgrass
-
Thank you @MarkSnodgrass. I changed the query to what you show and now I am receiving this error. I have not seen this type of error before - any ideas what may be going on? Column 'Item' in on clause is ambiguous
-
Thank you so much!!
-
Thank you for the reply! I changed my formula to the below, but it is returning the average of all the weeks rather than just the most recent week (CASE when MAX(MAX(`Fiscal Week`)) OVER () then (SUM(`Original Order Cases`)- SUM(`Cut`)) / SUM(`Original Order Cases`) end)
-
Thank you so very much Tadashii!
-
Thank you for the input. I did close the browser and re-try, but no luck. I should clarify something on my best mode. The formula does not seem to contain any syntax errors and I have validated the calculation within the beast mode itself. It does not, however, return any data when the card is in table form. Any…