Luke_Mielke Member

Comments

  • Thanks for the reply, however, I do not have the custom app auth option. This particular app is in the App Studio, the embed and navigation/interaction seems to work on everything else but the form within the app.
  • It looks like your first condition isn't looking for the previous month. WHEN Year = YrSelector AND 'Month' = MONTH(DATE_SUB(RecordDate, INTERVAL 1 MONTH)) THEN SalesValue If your data crosses Dec 2023 and Jan 2024, you'll also likely need something for that condition. WHEN Year = YrSelector - 1 AND 'Month' = 12 AND…