Bex Query element issue

[Former Member]

Help your help for sure.

Kindly see the screenshot below,

I have no clue to identify the problem exactly.

[former_member492038]

How are RM_Qty and OTH_QTY defined? The error suggests they aren't using the same dimension - are they both using the same UOM or alternately do they both have NODIM consistently applied (assuming they are calculated key figures themselves)?

[cornelia_lezoch]

hi RGI - would be nice if you told us your name when you ask questions ...

the formatting for the "Amount..." looks strange - it should be not in black.

just delete this part from the formula and insert it correctly again.

regards

Cornelia

[Former Member]

Hi,

Thanks for your reply,

Actually i am getting error in BO web intelligence report firstly,

So after that i have checked in particular bex query

i have used NODIM,then too i am getting the above error

[TammyPowlas]

I'm guessing here, based on this reply https://archive.sap.com/discussions/thread/3306390

I would try using NODIM( AMOUNT IN LOCAL CURRENCY * 70/100) - change the parentheses placement