Different units in total sum row

[Former Member]

Hello Bex Experts,

I have orders with different Units in a report. currently the total sum row show * for Mix

How can I get the total sum for ST and KG like

Total Sum 366 KG

Total Sum 342 ST

BR Matthias

[yasemin_kilinc · Accepted solution]

Hi Matthias,

You can add currency as a characteristic to the rows in the query designer. And select show result rows always.

Hope it gives an idea.

Regards

Yasemin..

[KodandaPani_KV]

Hi,

if you have 2 currenices(KG,ST)  in your report add the object in column panel.

if have more currenices add it in rows panel.

select the under query proparties disaly as the- always.

Thanks,

Phani.

[Loed]

Hi Matthias,

If you want to sum their numbers regardless of the UNITS, just use the NODIM() in formula..But if you need to add them and have 1 unit for the result, you must convert one of the them to another unit..

Regards,

Loed