formula question

I have this crystal formula

How can this be converted to a reporting services Expression

if {ITEMCODE} in ["A","B"]

then "TypeA"

else if

{ITEMCODE} in ["C","D"]

then "TypeB"

else

"TypeC"

Use this:

=iif((Fields!ITEMCODE.Value = "A" OR Fields!ITEMCODE.Value = "B") ,"TypeA",IIF((Fields!ITEMCODE.Value = "C" OR Fields!ITEMCODE.Value = "D"),"TypeB","TypeC"))

Hope this will work.

Regards,

Manoj Verma

|||

Hi Manoj

Is this the only way.

one of my formulas may have to have upto 100 or's?

Thanks for your help

|||

I don't think you may have any other option or if it is there then i'm not able to figure out.

Sorry....

Regards

Manoj Verma

|||

Thanks for your help Manoj

I will have to group them another way using another table!

Format_String Currency lost by division

Hello!

I use AS 2005 SP1.

If I create a calculated measure "C" with a currency measure ("A") and a non-currency measeasure ("B") like
C=A/B
and define the format_string for the calculated measure as currency. The result is still a non-currency value. Why?

Thanks in advance!
Ole JepsenIf you explicitly specified FORMAT_STRING='Currency' for the calculated measure C, then it will be formatted as currency.