Optimization Tool Issue

Question

Hi Team

I'm facing issue with the optimization tool. I have attached the workflow without optimization tool. I have two datasets 1 and 2 .

In the second dataset . I'm getting the expected results . However with the first dataset, I'm facing the issue.

Logic for this workflow :

Logic -1   Logic - 2  100.05 1:M 40.67 M:M-50.45   67.78  -50.60   -30.55  30.99   -44.33      -33.57      60.77

As shown in the amounts are getting written off based on 1:M and M:M (original data is scrambled).

@PhilipMannering

note : workflow attached does not have optimization tool due to my trial license

Pictures have been attached

Divyajyothi7 · Answer

objective is to balance positive and negative where sum is equal to zero.

for Example :

Input :

rowAmount1101.052-50.453-50.6430.99540.67667.787-30.558-44.339-33.571060.77

Expected output :

rowAmounttype1101.05balanced2-50.45balanced3-50.6balanced430.99 540.67balanced667.78balanced7-30.55balanced8-44.33balanced9-33.57balanced1060.77

As shown in the expected output  from row 1 to 2 sum is zero ( balance is done based on 1 : M combination , 1 positive and M negatives)
and from row 5 to 9 sum is zero ( balance is done based on M : M combination , Many positives and Many negatives)
I need to build a workflow which balances amount with combination

In the uploaded Excel, there are two datasets have been attached
Data set -2 is balancing correctly, giving the sum of amounts is zero
when i used same logic for data set-1, the sum of amounts is not equal to zero

is it possible to balance amounts without optimization tool

philipmannering · Answer

What is the objective here?

What are you trying to achieve?

The "Logic for this workflow" is just a list of numbers.

What does "1:M" and "M:M" mean?