3 Replies Latest reply: Oct 18, 2016 7:06 PM by Sunny Talwar RSS

    How to ignore selection on a text object scripting?

    Jim Chan

      Hi guys,

       

      I have a line of codes. I need to add this into a text object to display the total records. Problem is when i selected any of the filters, it changed.

       

      what else to change in this code so that wont be affected by filters. ?

       

      =(count({$<number = {'$(=max(number))'}, year = {'$(=max(year))'},likelihood_name={LOW},impact_name={LOW},status={DELETED}>} number) )

      +

      (Count(DISTINCT {<record_id = e({<record_id = {"=Count({<year = {'<$(=Max(year))'}>} record_id ) > 0"}>}), likelihood_name = {'LOW'},impact_name = {'LOW'}>} record_id ))




      rgds

       

      Jim