6 Replies Latest reply on Mar 2, 2017 6:44 AM by Yuriy Fal

    'Can't be applied to a user defined aggregate' error query on calculation

    Bruce Richardson

      Hi all,


      I have the following calculation i am trying to get into my worksheet.


      SUM([Mobile Entry])-[Existing Players Entries ]


      Mobile Entry is a boolean field (1,0).

      Existing Player Entries is the result of the below calc, where both [is_new_player] and [Mobile Entry] are also boolean fields (1,0)


      SUM(IF [is_new_player] = 0 THEN [Mobile Entry] ELSE 0 END)


      When I drag my first calculation, SUM([Mobile Entry])-[Existing Players Entries ], into my worksheet i get the error in the title.


      How can I get this calc into my worksheet without this error?


      Thanks in advance for any help and unfortunately I cannot publish any workbooks or data for this due to this being sensitive client data so apologies for that!