Page 1 of 1

Condition ">" in a crosstab

Posted: Tue Jul 05, 2016 9:27 am
by Jennypi
Hi,

I'm trying to set up a condition in a crosstab.
I defined the condition like this:

Code: Select all

value>3.5
The problem is that I'm getting this error message:
Sans titre.png
Sans titre.png (4.84 KiB) Viewed 1631 times
Why can't I use the > operator with a decimal??

If I put

Code: Select all

value >3
it is working perfectly.

Thanks!

Re: Condition ">" in a crosstab

Posted: Tue Jul 05, 2016 11:43 am
by Alex K.
Hello,

Please try to use the following expression:

Code: Select all

value > 3.5m
Thank you.

Re: Condition ">" in a crosstab

Posted: Tue Jul 05, 2016 1:09 pm
by Jennypi
Working perfectly, thank you!
What is the "m" for?

Re: Condition ">" in a crosstab

Posted: Tue Jul 05, 2016 1:39 pm
by Alex K.
Hello,

If you want a numeric real literal to be treated as decimal, use the suffix m or M.

https://msdn.microsoft.com/en-us/librar ... 2147217396

Thank you.