Hope you all had a nice break! I am getting this "Invalid field formula due to limitations in data source" error as I try to drag a calculated field on a "Marks" shelf. The calculated field is meant to be a filter of If/Else statement from two data sources (within the workbook).
If [Source.2].[Actual Cost] > Sum([Forecast Cost]) Then "Red"
ElseIf [Source.2].[Actual Cost] < Sum([Forecast Cost]) Then "Green"
Else "Grey" End
This calculation is logically correct, as in it yields no error while calculation, however putting it on the Marks shelf gives me the error.