Comments
-
Hey @jordan_platinum That is because curdate() (at least in my timezone) is 2021-08-31 so therefore it is the last day of the month and the portion of the beastmode after the division symbol is evaluating to a value of 1 so Domo is taking the value of 1.17M and dividing it by 1. Tomorrow the value would evaluate to 30…
-
Hi Jordan, You are super close, I think you just need to change the last part of your beastmode to look like this: DAYOFMONTH(LAST_DAY(CURDATE())) - DAYOFMONTH(CURDATE()) Note, because today is the last day of the month it currently evaluates to 0 so this would give you a divide by 0 error. You may want to add 1 to the…