Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

it solved half of my problem but i still need your help.

 

As shown in the below image I need to calculate the unit weight of each part with a thousand separators and "NA" if the mass is less than one which is done.

but now I need the extended weight which is (UNIT WT * QTY) with a thousand separators and "NA" if the mass is less the one in unit wt.

 

anuj16797_0-1671083801946.png

.

 

If iProperties.Mass > 999 Then
	iProperties.Value("Custom", "Totalmass") = iProperties.Mass.ToString("###,###")
	iProperties.Value("Custom", "UNIT WT") = iProperties.Mass.ToString("###,###") 
Else  
	iProperties.Value("Custom", "UNIT WT") = Round(iProperties.Mass, 0)
End If

If iProperties.Mass < 1 Then
	 iProperties.Value("Custom", "UNIT WT") = "NA" 
	 iProperties.Value("Custom", "EXT WT") = "NA"
End If