2 Replies Latest reply on Dec 18, 2014 11:03 AM by michael shin

    "Invalid field formula due to limitations in the data source" error for a calculated field

    michael shin

      Hello all.  I have a dashboard where I am adding another TDE/Excel file as an extract.  I data blend on Date.  So far, so good.  I even set-up a calculated field where I use a dimension from the primary source to dictate the measure in this new secondary data source.  The fact that this works tell me that my data blending is working fine. 

       

      However, when I take a measure from a different secondary data source as a numerator and take a measure for this secondary data source, I get the above error. Is this b/c you CANNOT data blend on 2 secondary data sources?  You can only data blend on a primary and a secondary?