cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Solution Sage

## Calculate the actual weight in a single unit of measurement

Hello my friends! Need your help.

I have 1 table, which consists of following collums: units (shops), product quantity, ID product; and second table: ID product, Weight

From 1 table we have already counted quantity of goods per unit.

The task is to count final quantity of goods in one unit (kg), while we have several of them. We need to do this by multiply quantity of goods (counted from 1 table) and weight (from table 2) that meets ID of product unit (from table 1).

We were able to accomplish that, but the problem is we have some units, that dont have weights, but in the same time we need to count quantity of them as well.

So in result we need to see (as in example) 9374,02 in units "pych." and 1739 in units "pack", the summary must be 9374,02+1739=11113

Exempl PBX

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
1 ACCEPTED SOLUTION
Super User

Hi @DimaMD

Try this measure:

``KG = if(ISBLANK([Weight]),[Quantity of goods],[prod.Quantity]*[WeightKG])``

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

2 REPLIES 2
Super User

Hi @DimaMD

Try this measure:

``KG = if(ISBLANK([Weight]),[Quantity of goods],[prod.Quantity]*[WeightKG])``

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Solution Sage

Hi, @VahidDM
Thanks, this is a good solution.

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com