cancel
Showing results for 
Search instead for 
Did you mean: 

formula error

Former Member
0 Kudos
37

hi,

when i give formula like revenue= price* quantity. error is throwing, wen i asked my frd he said deactivate the dimensions for currency and unit so that the query will give the revenue values, but i don't know wre to deactivate the dimensions...

Please help me in this regard,

Thanks,

Jagadeesh

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jagadeesh,

In the transfer rule of "revenue" keyfigure after selecting formula, in the area where you define the formula just specify "price* quantity" and save it. You need not add "revenue=" before the actual formula.

Thanks = points.

Regards

edwin_harpino
Active Contributor
0 Kudos

Hi Jagadeesh,

welcome to SDN ...

what your friend mean is use NODIM,

create 3 formula, right click 'keyfigure' and 'new formula',

then expand 'data function' choose 'value without dimension, no unit',

it will be displayed as NODIM, put price in, NODIM(price), e.g the name formula1

create the same for formula quantity, NODIM(quantity), formula2,

then create revenue formula = formula1 * formula2.

hope this helps.

Former Member
0 Kudos

Hi can u plese guide me how to do this ib detail ...coz i just started learning sap