Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following expression and I would really appreciate some help.
=Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt)
Is it possible to only show results where the result of the count is greater than or equal to 2?
Thanks,
Daniel
May be this:
If(Count({<extended_amt = {'>=$(vInputAmount)'}>} extended_amt) >=2, Count({<extended_amt ={'>=$(vInputAmount)'}>} extended_amt))
May be this:
If(Count({<extended_amt = {'>=$(vInputAmount)'}>} extended_amt) >=2, Count({<extended_amt ={'>=$(vInputAmount)'}>} extended_amt))
is this?
=if(Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt)>=2, Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt))
Thank you, that works perfectly.
Regards,
Daniel
Yes, you can do it
if( Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt)>=2,
Count({<extended_amt={'>=$(vInputAmount)'}>}extended_amt),0)
Awesome
Thanks for the above responses.
Unfortunately when validating my data, I noticed that it returns incorrect values for the count.
Even if I enter Count(extended_amt the values returned are incorrect. ie it returns two when there is only one item matching this value. Is there something I am doing wrong?
Regards,
Daniel
didnt understand your requirement what exactly you want but try Distinct:
=if(Count({<extended_amt={'>=$(vInputAmount)'}>} extended_amt)>=2, Count({<extended_amt={'>=$(vInputAmount)'}>} distinct extended_amt))
Yes, I agree with Balraj, amy be you need this:
If(Count(DISTINCT {<extended_amt = {'>=$(vInputAmount)'}>} extended_amt) >=2, Count(DISTINCT {<extended_amt ={'>=$(vInputAmount)'}>} extended_amt))
Can you upload your application Qvw?