1 Reply Latest reply on May 22, 2012 11:40 PM by Jonathan Drummey

    Row level calculation and high level aggregate -

    Rama Kunaparaju

      Hi,

       

      Please refer to the attached workbook and Excel data.

       

      Each COID has several PIDs. I have create a calculated field at the PID level which does the following.

       

      if count([EVER])=countd([ID]) and sum([INQ])=0 then countd([PID]) else 0 end

       

      So for each PID we have a value of 0 or 1 for the calculation. Out of the 162 rows you see in "sheet-1" 155 of them have a value of 1 and the rest have a 0 for the calculation.

       

      I want to do this aggregation at the COID level, but the calculation should be done at the PID level

       

      For example the second sheet should look like this

       

      COID  Calculation(1)

       

      1280      155

       

      I have tried a few things, but it seems like i am missing something. Please advise

       

      Thank you