Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a count in a textfield of a table where i want to count all the orders in a certain orderstatus (on hold).
in the table i'm showing every order in that status, but i would like to only count those where the date of creation (=OrderDate) is more than 30 days ago.
how would i need to adapt this formula to only count me the orders that exist already more than 30 days?
thanx!
chris
count ( DISTINCT if ( OrderStatus= 'On hold', OrderNumber) )
Hi,
You can use this expression--
count ( DISTINCT if ( OrderStatus= 'On hold' and OrderDate>=30, OrderNumber) )
And if your Order date is DateField then try this
count ( DISTINCT if ( OrderStatus= 'On hold' and Interval(Today-OrderDate,'dd')>=30, OrderNumber) )
Hope this help you..
U can write a expression below
=count ( DISTINCT if ( OrderStatus= 'On hold' and OrderDate<=Today()-30, OrderNumber) )
Regards,
Kabilan K.
HI,
Try this
Generally If stm work slow so try to avoid that.
Count (Distinct { 1 <OrderStatus= { 'On hold' } , "OrderDate<= Today()-30 ">} OrderNumber)
Regards,
Nirav Bhimani