Comments
-
Thanks @ColemenWilson ! This should be the solution I was looking for. Now I wait for the alert to trigger.
-
Thank you @Sean_Tully @MarkSnodgrass @GrantSmith ! Your answers are very insightful and helpful. I will definitely add them to my toolkit. I ended up using Mark's SPLIT_PART function as that was easiest and fit my criteria.
-
Hi @MichelleH , I wouldn't say new rows are added on a regular basis but I would like to track any changes whether that be new rows or changing quantities or prices which affect total value. I've never tried adding a relative date field to new rows. Do you have any resources that could help? Or any advice on tracking…
-
Hi @ColemenWilson , Thanks for your response. I tried that beastmode and applied it but it still displays Order Numbers that do not have UN Number. An example below: Null fields can be tricky sometimes with our datasets. We've had to use prompts such as When UN Number = '' and when length('UN Number') < 1 as well because…