MRVS - Calculate a total from 2 columns then a total of that colum

[Dave105]

Hi! 

Can anyone assist me with a request I have, to create a purchase requisition form, I am planning on using a MRVS, to totalise 2 columns within a row, i.e. Quantity x Unit Price = Total Price. (e.g. Quantity is 2 x Unit Price is 75 = Total Price 150). If this was in Excel, for example, this would be A3 * A4 = A6

I then need to further add all row Total Price values in to a Full Request Total Value, for example, A6 + B6 + C6 = D6 - this would obviously have to be set to calculate all lines added in the MRVS, whether it be 1 or 5 or 20 etc...

Thanks in anticipation

Dave

[Community Alums]

Hi @Dave105 ,

Please follow the solution:https://www.servicenow.com/community/developer-forum/how-to-calculate-the-sum-of-the-value-in-multi-...

[Dave105]

Hi Sandeep,

Thanks for the quick response - I am looking at that solution now but hoping someone has actually managed this within an MRVS

Regards

Dave

[Community Alums]

Hi @Dave105 ,

Great to see, you got the solution.