12-14-2022
09:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
12-14-2022
09:57 PM
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.
.
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