-
I need to know what is the date 5 previous business days from current day, including holidays
The domo data set for calendar has columns for isHoliday and is workday, but how do I find the 5th previous day from a given date that contains 5 business days. For example, if the date is 11/28/2022 it should return a date of 11/18/2022 because there is 1 holiday (11/24) and two weekends(total of 5 non working days).…
-
Working on a shipping report that needs Net on Hand by item that recalculates in Analyzer
In the analyzer table, the user will sort by different columns and I need the Net on hand to adjust based on the order chosen for each part in the set. For instance, if they are looking at it by customer name, or by order number, the net on hand for those items needs to dynamically change so that Net On Hand is reduced in…
-
I have a column of part numbers and I need to exclude any rows where a part number has a character
Example Parts: '0055656','1248000', 'D9989008','0556767P' I need to exclude rows where the third and 4th part in list above exist. First and last characters can be any member of the alphabet. Thanks, Mike
