_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…
    in FIXED Function with filter on card Comment by _DanielB_ May 27
  • Thanks @ColemenWilson I'll give that a try :)
    in Previous Month Last Year value Formula Comment by _DanielB_ March 27
  • 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…
    in Previous Month Last Year value Formula Comment by _DanielB_ March 27
  • 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!
    in Apply a % Model based on an identifying field Comment by _DanielB_ March 5
  • 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 :(
    in Filter Line without Column Turning Blank Comment by _DanielB_ March 5
  • 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 😊
    in SUBSTRING Query (9 day n00b question) Comment by _DanielB_ January 28
Default Avatar