Forum Discussion

kelly008's avatar
kelly008
Helper I
4 years ago
Solved

Multiplication between Tables

Hello,   I currently have 2 values from 2 seperate tables, I am trying to multiply them together but when I do, the total for the column is way out:   For some reason it is 44,964.38 wh...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi kelly008 ，

    Is there any relationship created between the table SYNProdOrderLine and SYNBOMDetails? If so, which fields are they based on? Could you please provide me with the Fields pane settings for your table visual?

    Relationship info

    Fields pane setting

    You can create a new measure based on the measure [Quantity_per_Unit x Quantity] as shown in the figure below, please find the details in the attachment.

    Measure = SUMX ( VALUES ( Field with Text type on the table visual except for the field [Quantity_per_Unit],[Quantity] and the measure [Quantity_per_Unit x Quantity]  ), [Quantity_per_Unit x Quantity] )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi kelly008 ，

Is there any relationship created between the table SYNProdOrderLine and SYNBOMDetails? If so, which fields are they based on? Could you please provide me with the Fields pane settings for your table visual?

Relationship info

Fields pane setting

You can create a new measure based on the measure [Quantity_per_Unit x Quantity] as shown in the figure below, please find the details in the attachment.

Measure = SUMX ( VALUES ( Field with Text type on the table visual except for the field [Quantity_per_Unit],[Quantity] and the measure [Quantity_per_Unit x Quantity]  ), [Quantity_per_Unit x Quantity] )

Best Regards