Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Bro Sunny,
how to ignore other selections affecting my figure???
Rgds,
Jim
May be this:
=Count(DISTINCT {1<Record_ID = e({<Record_ID = {"=Count({<Year = {'<$(=Max(Year))'}>} Record_ID) > 0"}>})>} Record_ID)
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)
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)
=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
Nope,. i have tried still able to filtered by other selection.
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)
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)