Need help with Month Function in Beast Mode

I'm trying to set up a beast mode formula to calculate YTD Asset Yield. It doesn't seem to work because of the Month function. I also try to create a formula for Month(`Monthend Date`) within the ETL, and that did not work too. Do you know if there is a reason why this does not work and do you have any suggestion to make this work? Thank you!

Answers

  • @haipham What specifically didn't work? Did you receive an error in the ETL or did it return an incorrect value?