2 Replies Latest reply: Oct 3, 2016 2:58 AM by Josephinet Tedesco RSS

    My Aggr or set analysis problem

    Josephinet Tedesco

      Hi All

      I have been trying to do get a total total cost:




      Total 293


      The formula for getting the no of Records is


      count(distinct{<ClassTypeName = { 'Sim'}>}([RecNo()]))



      How do I get the total COST which is costWeight * No. Recs


      I have read about aggr function but I do not know where to apply the function.


      Thank you for any help you can give.