Query Designer...If then, else if then, else if then else.

[Former Member]

how would you write a statement like this in Query Designer(see below) for characteristics or key figures? Could I do it in the properties pane for a characteristic or a key figure. Please advise. Or, do i have to write abap in the backend which i'm trying to avoid b/c my users don't have access to the backend. Thanks.

If then, else if then, else if then else.

[Former Member]

Hi,

Its very simple to find the link in help.sap.com. If you didnt read the doc already, then check out the below link:

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm

Regards,

Vivek

[Former Member]

Hi,

You cannot write this in the properties pane of the Characteristic or Key figure. You can make use of formula or calculated keyfigure to write the If condition. It will follow as below.

(KF1 > KF2)*KF3+KF1.

To use the characteristic as keyfigure you have to create a Formula variable with Replacement path processing type. And use this in the Formula as normal keyfigure. Keep in mind you should have the Numeric values for the Characteristic to convert in to the Key figure.

Thanks,

Khaja