Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Used below expression but still it is showing '-'.
IF(ISNULL(count(order))='-', 0,count(order))
Hey Abhi,
IF(ISNULL(count(order))='-', 0,count(order))
If the order field having multiple null values(-) then count of order produce the count is does not gives the (-) . so automatically it provides the count of order as a output.
So Try this simple if condition,
=if(Order = '-', 0 , count(Order)) // if the order field has - it replace those value with 0 or else give the count of order
Regards,
Durga