_DanielB_ Member

Comments

  • Hi @ArborRose, I had to move the FIXED function to the end of the BM as it returns a syntax error when placed at the start. Also, when I filter out the 'Type' = Revenue on the table itself, the BM show 0 for everything which I know is incorrect Incidentally, the one I've created is no good as it naturally ignores filters…
  • Thanks @ColemenWilson I'll give that a try :)
  • Hi @ColemenWilson I need to create the formula in the ETL as I have to include it in other calculations in my output dataset I tried the below but that didn't return any values and there are definitely values for last year CAST( CASE WHEN YEAR(`Month`) = YEAR(CURDATE()) -1 AND MONTH(`Month`) = MONTH(CURDATE()) -1 THEN…
  • This might be the most in depth and detailed response I've ever received to a challenge before! Thank you so much.. When I am back on this project, I will be implementing this solution!
  • Aye, I'm pretty sure as I'm saying in the calculation above ( Hierarchy = 'Revenue') and then filtering out the respective line item, I end up with the problem you've mentioned Sadly, I'm only a few months into using Domo so I haven't discovered a solution to the aforementioned problem :(
  • Thank you @ColemenWilson - I'm currently undergoing a 'trial by fire which is on fire' and I'm still getting used to all the functions within Domo 😊