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.