Fellow Community Gurus,
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.
Any clues to what I might need to check?
One of the less helpful messages...
I've had it before and solved it by extracting the data - I wonder if that's a possibility for you?