cancel
Showing results for 
Search instead for 
Did you mean: 

Can we Sum the Values in the Qualified table Fields??

Former Member
0 Kudos

Hi All,

I have a requirement where..Each material has multiple UOM's, So designed it as Qualified Table.

UOM is a Qualified table.

UOM Type is NON Qualifier.

Weight Qualifier - Integer field

Length Qualifier - Integer Field

Now in main table there is a field called Net Weight.

I need to write a validation which checks Whether Sum of ''Weight'' in Qualfied table is Equal to ''Net Weight'' for that record.

So if there are 5 UOM for 1 material, then the validation should check whetehr the Sum of all 5 Weights in QT is equal to ''Net Weight'' Field in Main table!!!

Did anyone faced a similar issue, If yes How did you solve it!!

Please Help!!

KR

John

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi John,

Try this:-

Net Weight = SUM(UOM.Weight)

Here SUM is the standard function thats u need to select from list of functions.

Please let us know if it works..

Thanks,

Mahi

Former Member
0 Kudos

Thanks.

Yes it is working fine.

thanks for the Quick Update.

KR

John

Answers (0)