Calculate the actual weight in a single unit of measurement

[DimaMD]

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

[VahidDM · Accepted solution]

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.

Appreciate your Kudos!!

[DimaMD]

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