Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Sirs ,
how to be the expression to find count of previliged traders (EMP) which are having zero bidding_id during period selected .
with no change in present only data model structure .
Thank you .
Try this
=Count({$<Trader_Name = {"=(Count({<Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID) + Sum({1} 0)) = 0"}, Marker = {"Previlaged"}>} DISTINCT Trader_Name)
What is the expected output based on the data within the sample and selections made?
Thank you sir for replying
My result should be
PIC FOR REFERENCE
if you see in reference pic i am getting my results by doing filter in excel with two expression ,
i want a single set expression that should give me count in TEXT BOX ,
all those trader which are privileged but have no complete bidding id in the period selected in calender box ..
Try this
=Count({$<Trader_Name = {"=(Count({<Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID) + Sum({1} 0)) = 0"}, Marker = {"Previlaged"}>} DISTINCT Trader_Name)
I think its not working properly . try range - 1/july/2018 to 12/nov/2018
Yes, because between those two dates, all the Traders seem to have bid for at least 1 bid. Wouldn't that cause you to see 0?
Sorry sir i think , i made mistake , your solution is correct .. let me double check .
Sunny, can you explain why you use [ instead " or ' ?
Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID)
Thanks
Since this whole thing is part of a bigger set analysis... I used [] instead of escape sequence
=Count({$<Trader_Name = {"=(Count({<Date_of_Bidding={[>=$(=Date(vStart_Date, 'DD-MMM-YYYY'))<=$(=Date(vEnd_Date, 'DD-MMM-YYYY'))]}>} Bidding_ID) + Sum({1} 0)) = 0"}, Marker = {"Previlaged"}>} DISTINCT Trader_Name)
Ok, understood. Thanks!