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

[sunny_talwar]

May be this:

=(Count({1<number = {'$(=Max({1}number))'}, year = {'$(=Max({1}year))'},likelihood_name={LOW},impact_name={LOW},status={DELETED}>} number) )

+

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

[jim_chan]

Bro,

The figure goes wrong when added 1.

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

Rgds,

Jim

[sunny_talwar]

‌Really? I would have not expected that. Can you provide a sample of screenshots of what you are seeing?

Best,

Sunny