8 Replies Latest reply: Jun 13, 2013 8:27 AM by viral parikh RSS

    Set Analysis - Function Inside Function

    Byron Van Wyk

      Hi All,

       

      I have the following set analysis function

       

       

      count({<PayRate={"$(=min(Total<ClientName,TempName,CategoryDesc,Invoice>PayRate))"}>}TOTAL<ClientName,TempName,CategoryDesc,Invoice>ChargeRate)


      The function in the "" works perfectly when done on its own. As an example it gives me a value of 27 on the first row. I want to use this "dynamic" function in a set analysis expression.

      I want my expression to count the number of times there is a charge rate for the min value over the following aggregation. I have used the TOTAL function as I need this to display on all rows.

      What am I doing wrong folks


      Thanks,
      Byron