I want to convert the total quantity into several units and the fields that I have to use it are in three tables. what solution do you propose knowing that I tried this code but it did not work
LET vconvert = '= Minstring';
Conversion_des_Unites:
CROSSTABLE (Conversion_des_Unites, Units) LOAD
Index,
Kg,
g,
q,
hg,
dag,
dg,
cg,
mg
RESIDENT Units;
Conversion_des_UnitesList:
LOAD convert as
RESIDENT Conversion_des_Unites
WHERE Conversion_des_Unites > 0;
DROP TABLE Conversion_des_Unites;