Condition ">" in a crosstab

[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 (4.84 KiB) Viewed 1626 times

Why can't I use the > operator with a decimal??

If I put

Code: Select all

value >3

it is working perfectly.

Thanks!

[Alex K.]

Hello,

Please try to use the following expression:

Code: Select all

value > 3.5m

Thank you.

[Jennypi]

Working perfectly, thank you!
What is the "m" for?

[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.