Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with a field called T0, in this format DD, hh:mm:ss, the idea is to make a table that only count the values major to 00, 00:30:00, I used the expression :
Count(if(T0 >= 00, 00:30:00, T0))
but the expression editor shows an error.
How can I do that ?
Hi,
Do you have any sample of this it will be more easy.
Regards,
Anand
You need to quote strings, otherwise you will get an error. I am not convinced that your expression will work, depending on what data type T0 has. So if it does not work, please attach a QVW sample to enable more detailed advice.
The expression needs quoting;
Count(if(T0 >= '00, 00:30:00', T0))
Hi,
Yes you need to write a check code it single quotes like Count(if(T0 >= '00, 00:30:00', T0)) like Toni suggested it is also depents on your data type of 00, 00:30:00 field it is then you need to check, if you have any sample will be easy.
Regards,
Anand