How to calculate the sum of all records amount variable in a Multi Row Variable Set

Go to solution
tanuja_g
Tera Contributor

‎10-22-2024 12:37 AM

In a MRVS, I have one variable called amount. Have to calculate the sum of all the records amount. If amount is lesser than or is 100.00 it should display approval1 variable so that user can select approver. If the amount is greator than 100.00 it should display approval2 variable. 

tanuja_g_0-1729582526373.png

 

Any solutions should be helpful.

Thanks in advance.

0 Helpfuls
  • 1,807 Views
1 ACCEPTED SOLUTION
3 REPLIES 3

Go to solution
tanuja_g
Tera Contributor
In response to dgarad

‎10-22-2024 02:20 AM - edited ‎10-22-2024 11:21 PM

Hi dgarad,

Thank you so much, that post helps me alot.

But When we delete or remove any of the records in MVRS - The amount variable remains same with the total value of intial records. The amount is not getting changed(Not subtracting the specific value of deleted records)

How to overcome this drawback?

0 Helpfuls