How to display new and deleted records using expression?

[jim_chan]

Hi guys,

I have 2 years of data loaded in. Now client want to know what is the created record_id. But unfortunuatelty, under status - there's no value of "NEW" but just have 'deleted' and 'active'

So, how to  display new records using expression?

Rgds,

Jim

[sunny_talwar]

Try this:

=Count(DISTINCT {<Record_ID = e({<Record_ID = {"=Count({<Year = {'<$(=Max(Year))'}>} Record_ID) > 0"}>})>} Record_ID)

What is the expected output for your second text box?

[jim_chan]

Bro Sunny,

how to ignore other selections affecting my figure???

Rgds,

Jim

[sunny_talwar]

May be this:

=Count(DISTINCT {1<Record_ID = e({<Record_ID = {"=Count({<Year = {'<$(=Max(Year))'}>} Record_ID) > 0"}>})>} Record_ID)

[sunny_talwar]

Or you might need 1s here also:

=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>})>} Record_ID)

[jim_chan]

i tried to create the expression like this, but working. after i put 1, the figure is even larger.

=Count(DISTINCT {1<a_rate_name ={'LOW'}, b_rate_name= {'LOW'},risk_item_id = e({<risk_item_id = {"=Count({<batch_year = {'<$(=Max(batch_year))'}>} risk_item_id) > 0"}>})>} risk_item_id)

[kkkumar82]

=Count(DISTINCT {<Record_ID = e({<Record_ID = {"=Count({<Year = {'<$(=Max(Year))'}, Field2=,Field3=>} Record_ID) > 0"}>}) ,

Field2=,Field3=>} Record_ID)

Try this, hope it may help

[jim_chan]

Nope,. i have tried still able to filtered by other selection.

[sunny_talwar]

Did you try this one:

=Count(DISTINCT {1<Record_ID = e({1<Record_ID = {"=Count({1<Year = {'<$(=Max({1}Year))'}>} Record_ID) > 0"}>})>} Record_ID)

[jim_chan]

quite close to the filtred figure. but still not correct. am i missing anything from this line bro?

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