Bex query formula produces an error

[Former Member]

Hello, Experts!

Need your help. In a BEX report I need to create a calculation

ANSP % Discount to GLP = Gross List Price - ANSP.

Query check produces an error :

Diagnosis Additional elements are added to the item ANSP % Discount to GLP that do not have the same dimension, for example, quantities and amounts or amounts and ratios.

Gross List Price is defined as 0currency and

ANSP is formula itself

Gross sales (0currency)/(Quantity (0quantity)*Conversion Factor (variable defined as a number))

What would you suggest to solve this problem.

Thank you for your help

[Former Member · Accepted solution]

ANSP % Discount to GLP = Gross List Price - ANSP.

as the error suggests, the formula is not right. You cannot subtract gross list price from ANSP. they do not have the same units.

[Former Member]

make your Gross List Price "unitfree" (by creating a new formula on that element only using NODIM() )

[Former Member]

Thnaks, I'll try that