Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm really scratching my head on this one. Can anybody please explain to me why set expression A. works fine whereas set expression B. gives me an error ( ',' or ')' expected?
A.
{<[Claim ref]={"=aggr(rank(avg({< [Claim now 100% USD]={'10000'} >} [Claim ref]))) <=$(v_#LATEST_CLAIMS)"}>}
B.
{<[Claim ref]={"=aggr(rank(avg({< [Claim now 100% USD]={">10000"} >} [Claim ref]))) <=$(v_#LATEST_CLAIMS)"}>}
RGDS//Peter
Hi,
The only difference between A. & B. is {'10000'} vs {">10000"}, changing from a fixed value to a search string.
@Anil_Babu_Samineni there is data available.
@theoat not giving the expected result.
Nevertheless, I solved this by using an "if" statement instead. RGDS//Peter
If(
aggr( rank(avg({< [Claim now 100% USD]={">=$(v_CLAIM_AMOUNT_LIMIT)"} >} [Claim ref])), [Claim handler])<=$(v_#LATEST_CLAIMS),
......
@peterstalberg the fact could be you don't have any records that is >10000, Instead In case you need that is with 10000, Perhaps this try with >=10000
Have you tried this ?
{<[Réf. de réclamation]={"=aggr(rank(avg({< [Réclamez maintenant 100 % USD]>10000 >} [Réf. réclamation]))) <=$(v_#LATEST_CLAIMS)"}>}
Try comparing them using Notepad++ with the 'compare' plug-in to look for differences
also what version of QS is this on.
Hi,
The only difference between A. & B. is {'10000'} vs {">10000"}, changing from a fixed value to a search string.
@Anil_Babu_Samineni there is data available.
@theoat not giving the expected result.
Nevertheless, I solved this by using an "if" statement instead. RGDS//Peter
If(
aggr( rank(avg({< [Claim now 100% USD]={">=$(v_CLAIM_AMOUNT_LIMIT)"} >} [Claim ref])), [Claim handler])<=$(v_#LATEST_CLAIMS),
......