Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
In my dataset there is 1 flag which has values Y and N. There are few customers in Y and few in N but there are common customers as well which has both Y and N status. I want to show the common customers. Is it possible to achieve in front end with set analysis.
I tried this expression - Sum({<Doubtful={'Yes'},Doubtful={'No'}>}Amount)
This is giving me all the customers not the customers that have both doubtful Y and N.
Any suggestions to do it in front end.
Thank you
Best Regards
Neha
Hi @Neha_2227 ,
Please give it a try with below expression
sum(if( Doubtful='Yes' and Doubtful='No' ,Amount))
This wont work as Doubtful field doesn't have both values together, either it has Yes or No at time.
Hi @Neha_2227 ,
Got it...
Is it possible to share the sample data? want to check if my second logic works or not
try below expression
Sum({<Doubtful={'Yes'} > * <Doubtful={'No'}>}Amount)
Here you go
As you pointed out, each row only have Yes or No. An intersect between the two will not give any result. Consider looking at implicit set analysis using E(). I will look something like this:
Sum({<CustomerId =P({<Doubtful={'Y'} > } CustomerId) * <CustomerId =P({<Doubtful={'N'} > } CustomerId)>}Amount)
Hi,
Please find the attached .QVF file
Might be this will help you.