8 Replies Latest reply on Nov 10, 2016 4:08 AM by yogesh sawant

    Creating a calculated field with measures from 2 different data sources

    Jagdeep Bhogal

      Hi all,

       

      I have a single workbook with 2 data sources. I want to create a calculated field that uses measures from each of the 2 data sources. The problem I keep having is that when I write out the calculated field, I keep getting an error that says 'cannot mix aggregate and non aggregate functions'.

       

      Both measures are 'number' types but it just won't seem to recognize the function.

       

      What I'd like to do is divide the measure from one data source, by the measure from the other.

       

      Any ideas?

       

      Thanks

       

      Jag