How to combine when and & in a calculated filed

[BjornSkifs]

I try to combine WHEN and the logical operator AND in a calculated field, but I can't get it right.

Among other things, I have tried the following:

CASE

WHEN ([@field:Language]='English')&([@field:Country]='USA') THEN 2

ELSE 1

END

I have also tried to construct the problem so that I can avoid using the AND operator, but I haven't succeeded. (The actual problem is more complex than the above example).

Any suggestions as to how I should write this? Is it even possible to combine WHEN and AND in this way?

I'm very grateful for any help.

Bjorn

[HongTaiLang]

The "and" logical operator is "AND" in Transact-SQL http://msdn.microsoft.com/en-us/library/ms189773.aspx. Please try this:

CASE

WHEN ([@field:Language]='English') AND ([@field:Country]='USA') THEN 2

ELSE 1

END

[BjornSkifs]

The "and" logical operator is "AND" in Transact-SQL http://msdn.microsoft.com/en-us/library/ms189773.aspx. Please try this:

CASE

WHEN ([@field:Language]='English') AND ([@field:Country]='USA') THEN 2

ELSE 1

END

Thank you so much for your reply HongTaiLang! And also thanks for the link, it will help me tremendously!

Have a nice week

[Aether]

For more information about this, you can also check Caspio's online help center:

https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

I hope this helps