_DanielB_

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

_DanielB_ Member

Comments