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 ))