Formula Numeric Fields with Conditions
I have a field called Year to Date Sales. I also have a field called Reporting Year. I have a report that needs to bring in that Year to Date Sales figure into the appropriate year i.e., 2019, 2020, e...
Forum Discussion
My Year to Date Sales field is a formula numeric because it is a sum of fields Q1-Q4. When I add your formula, the Year to Date Sales is highlighted and the warning of "Expecting date but found number". I also tried If(Year[Reporting Year] = [CurrentYear],[Year to Date Sales], null) but it didn't like that either.