I need help in scripting my form to calculate transaction value for minority vendor based on the vendor classification (MBE or WBE).
The dollar spend table should sum the value of purchases based on whether the vendor is MBE or WBE. The script should also include the % of the sum of invoice total for MBE and the WBE. I already have the right script to sum the total dollar value for purchases. Thank you in advance for your help.
Vendor Name | vendor type MBE/WBE | $ value of purchases | date of transaction | support Doc. # |
---|
| | | | |
| | | | |
| | | | |
| | | | |
| | Total | | |
Contractor Invoice Total $ Spend for the Month |
---|
|
Minority Type | dollar spend | % dollar spend |
---|
MBE | | |
WBE | | |
| | |