5 Replies Latest reply on Jul 19, 2018 5:41 AM by Jim Dehner

    Cannot Blend Secondary Datasource Error

    Diane Royer

      I am working with a large workbook that involved several different data sources.  When I add a data source to calculate the expenses for a department, I receive the error message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation".  I've searched for solutions and tried each one I found.  No matter what I do, I still get this message.  I ensured that both link fields from my primary data source are in my view.  I am using a sum function {fixed [SCHOOL]: SUM([TRANSACTION_AMT])}.  I did not use one of the link fields in my calculation (the link fields are School Cde and Fiscal Yr).  Is there anything else I can try?  I don't know what I'm doing wrong.

       

      Any assistance would be greatly appreciated.