Not able to define transfer rule

[kalpesh_pandey]

Hi, I am working on SAP Netweaver 7.0 and is trying to define transfer rule for Keys. I want to calculate revenue as rev = Price * Quantity

I am getting error message as "Formula ELement does not match type". The Keys are defined as below:

REV5 datatype as CURR type Amount

Quantity datatype as QUAN type Quantity

PRICE datatype as CURR type Amount

I am using Transaction RSA1OLD to work on old SAP BW.

Below is the text in help with which I m confused.

====================================

Formula element does not match type /BIC/OIIO_REV5

Message no. SFB525

Diagnosis

The selected formula element is of the type BOOLEAN. At this point in the formula, however, the system expects an element of the type /BIC/OIIO_REV5.

Procedure

Enter a formula element that matches the type /BIC/OIIO_REV5.

================================================

Seeking help one more time..

Thanks in advance,

[Former Member · Accepted solution]

Are you working in Bex, or in transformation ?

[kalpesh_pandey · Accepted solution]

Hi, I am working on transformation. I guess I need some documentation how to define transformation in Netweaver 7.0.

[Former Member · Accepted solution]

Hi Kalpesh,

This will give you a basic idea of transformations:

[Transformations in BI7.0|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6090a621-c170-2910-c1ab-d9203321ee19]

Hope it helps

Reward if useful

Manish