Get the input value by adding value in datatable

Help Activities
, , , , , , , , , , , , , ,
1

Both data table and value will get as input

Ex

Value=159.87

Datatable

Type. Value
A. 76.29
B. 76.29
C 76.29
Output will be:

So the if i need to 159.87 so need to take Output1 :76.29 next data Output 2: 76.29 and remaining amount Output 3:7.29 from third 76.29 adding will get the input value
So 76.29+76.29+7.29=158.87

Scenario2Both data table and value will get as input

Ex

Value=83.67

Datatable

Type. Value
A. 76.29
B. 76.29
C 76.29
Output will be:

So the if i need to 83.67 so need to take Output1 :76.29 next data Output2:7.29 from second 76.29 adding will get the input value
So 76.29+7.29=83.67

2

Hi @sruthesanju ,

A little more detail about this, would make example with Excel easier to understand your question.

if possible try to explain following keys “remaining amount”,“Output1”,“Output2”,“from second 76.29 adding will get the input value” and “input value”

Thanks,
Rajkumar