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:

       

       

           

      ClassTypeClassTypeDesccostWeightNo.RecsCost($)
      Total 293
      SimOPS11.51$1.50
      OPS32.7143$116.53
      OPSL43.3592$308.20

       

      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.