Forum Discussion
YTD Calculation without Date Field
Hey, I'm trying to figure out the best way to have YTD calculations in data that is using a fiscal calendar that puts days in different months. My dataset (SalesData) has a Fiscal-Month field as wel...
Hey, I get a big error message that starts with "The syntax for 'Year' is incorrect.". Would it be easier if I didn't need a true YTD calendar but rather something that would go through the previous period? So even if I am running it on 12/20, I just need the YTD data to be Jan-November.
Which calculated column were you creating when you got the error message?