CASE WHEN syntax w/ multiple conditions

We're trying to build a formula using CASE WHEN syntax with multiple conditions using AND.

Example:

CASE WHEN MIN(MNDIFF([time A], [time B])) <= 30 AND [column A]='Value' THEN DUPCOUNT([column B]) ELSE 0

This syntax is not working. Any tips?

bminehart

Posted 1 year ago·Last reply 1 year ago

6 comments

DRay

·1 year ago

I wanted to check in with you to see if you still needed help with this. Can you let us know?

Thank you.

Garrett Wolfe

·1 year ago

bminehart CASE statement on strings will work in the cube. We have pushed these calcs upstream to the cube or database level.

DRay

·1 year ago

I wanted to check in with you to see if you still needed help with this. Can you let us know?

Thank you.