Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I have following Expression which is working well.
Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {"$(=Max(TRAN_DATE))"}>} DISTINCT POLICY_NO)
but when I add the part in red the following expression does not work
Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {"$(=Max(TRAN_DATE))"},END_DATE = {"$(=Max(TRAN_DATE)-1, 'DD-MMM-YY')"}>} DISTINCT POLICY_NO)
Pls help me
END_DATE = {"$(=Date(Max(TRAN_DATE)-1, 'DD-MMM-YY'))"}
Hi Antonio
Still the result is 0
END_DATE is in DD-MMM-YY format?
Yes Sunny
A single POLICY_NO can have single TRANS_DATE or multiple TRANS_DATE?
Basically a single TRAN_DATE but sometimes multiple dates can occur
In you screenshot above, do you have Date(Max(TRANS_DATE), 'DD-MMM-YYYY') = '15-Aug-2017'?
Yes Sunny
Try to split and check where you are not getting. Like this?
Count({<RENEWED_PREMIUM = {'>0'}>} DISTINCT POLICY_NO)
Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {'$(=Max(TRAN_DATE))'}>} DISTINCT POLICY_NO)
......