Message in BEx Query Designer Formula

[former_member664877]

Hi Experts,

I need to display message based on the value of the formula result. For Example:

If K.F1 =<2.5 Then <Message: ODD>

ElseIF K.F1 >2.5 Then <Message: Even>

Else

<Message: Determine the value>

EndIF

Thease above messages would be build in the formula column of BEx query designer

Thanks and really appreciate your response.

Regards,

Waseem

[waqar_ahmed]

hi,

You can use exceptions in query for this purpose, as I dont think there is any way to do this. You can use different color scheme when result goes above or below 2.5.

Regards,

ray

[Anand71]

Hello,

I have done the same funtionality with the help of workbook.

May be experts can guide us how to display messages in the formula column of BEx query designer.

Thanks.

With regards,

Anand Kumar

[Former Member]

Hi,

I think it is possible only either in Workbook or in WAD, as there are no options in QD to write any codes...

Good Luck.

Vikram