1 Reply Latest reply on Jan 2, 2013 5:54 AM by Alex Kerin

    Invalid Field Formula

    Wolverine .

      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?

       

      Thanks,