Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me correct this Set Analysis
Count({$<ShipmentStatus={'READY'}, DATE={$(=Today())'}>}DISTINCT(CarrierID))
My Requirement is Count of Distinct 'CarrierID' based on ShipmentStatus='READY' for only Today.
How to achieve this?
Hi Sunny,
Finally this is worked. Thank you.
Count({$<ShipmentStatus={'READY'}, DATE={"=date($(vToday))"}>}DISTINCT(CarrierID))
maybe there is just a single quote missing in DATE set modifier:
Count({$<ShipmentStatus={'READY'}, DATE={'$(=Today())'}>}DISTINCT(CarrierID))
May be this:
Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(), 'YourDATEFieldFormat))"}>}DISTINCT(CarrierID))
Still no luck !! My Date fileld name is DATE..
Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'DATE'))"}>}DISTINCT(CarrierID))
Not DATE here
Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'DATE'))"}>}DISTINCT(CarrierID))
but the format, like MM/DD/YYYY or DD/MM/YYYY or DD-MMM-YYYY. Whatever format DATE has, need to go within the single quotes.
HTH
Best,
Sunny
Hi Sunny,
Still no luck!!
Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'MM/DD/YYYY'))"}>}DISTINCT(CarrierID))
Have you made sure that you have CarrierID for today's date where ShipmentStatus = 'READY'??
have you checked the variable value what your getting ?? and make sure that both the dates have the same format
Hi Sunny,
Finally this is worked. Thank you.
Count({$<ShipmentStatus={'READY'}, DATE={"=date($(vToday))"}>}DISTINCT(CarrierID))