Writting a measure in IDT.

[Former Member]

Dear Gurus:

I want a measure to be written in IDT. I have three conditions and once these three conditions fulfilled i want a sum of the specific field.

Kindly guide me with syntax and which statement should I use to achieve this, as I am not a programmer.

[former_member4998]

Hi

Use the CASE statement, find the below sample code.

CASE WHEN

Table.Field =1

THEN 'Low'

WHEN Table.Field  ='2'

THEN 'Medium'

WHEN Table.Field  ='3'

THEN 'High'

WHEN Table.Field  ='4'

THEN 'Very High'

END