19 Replies Latest reply: Feb 3, 2017 2:03 PM by Jim Chan RSS

    Count expression incorrect

    Jim Chan

      HI guys,

       

      I;ve managed to get a list of new records based on script.  but i dunno what is missing.

       

      =Count(DISTINCT {<risk_item_id = e({<risk_item_id = {"=Count({<batch_year = {'<$(=Max(batch_year))'}>} risk_item_id) > 0"}>})>} risk_item_id)

       

      Based on the above script - i manage to get the correct new records - which is 67.

       

      But when select filter  risk1 'low and risk2 'low' then i got the wrong figure, 104. is wrong.

       

      The result should be 49, after i have filtered with risk1 and risk 2.

      screenshot1.jpg

      screenshot2.jpg

       

      rgds

       

      Jim