Can't get right value

[#1]

I have a problem for this relations

I have a table for conversion as this

ItemId        Factor          FromUnit          ToUnit

and I have a table for transactions as

ItemId          Qty          GroupId          UnitId

my question, when I set an expression in the chart as (Sum(Qty) for ItemId / Sum(Qty) for GroupId related with ItemId)

When I do it that I cant right value for conversion equation.

[fred_s]

Can you share your file, with some (sample) data?

Grtz Fred

[#3]

Hi fadibarri

Can you Share your File

[morganaaron]

How are you writing the expression?

If you want the % breakdown for each group of the items within it, try creating a table with GroupID and ItemID as your dimensions, then use Sum(Qty) / Sum(Total <GroupID> Qty) as your expression.

Otherwise, what is it you want from your conversion table?