Multiple Condition of Data addition and minus

SH_94

Hi Community,

I would like to ask how we can build the workflow so that it able produce the result as per screenshot below. I have few condition in order to achieve the final result:

1. I would like to join the data A and data B before performing data addition or data minus.

2. Once it is combined, i have the criteria as below:

   - If type is A, the amount from data A will be add together with amount from data B

   - If type is B and C, the amount from data A will minus the amount from data B

   - If type is D , the amount from data A will be add together with the amount from data B

I know how to build the step 1 in this case, but i not sure how to build the workflow for the second step.I also included the excel file below for your reference

Multiple condition, addition or minus.xlsx

AngelosPachis

Hi @SH_94 ,

As you can see for yourself, when you typed the question you used the word IF many times, so again you are looking for an IF expression.

That probably would be:

IF [Type]="A" THEN 
//1.
     IF [Subtype]="AA" THEN [Amount]-[Amount Data B]
     ELSEIF [Subtype]="AB" THEN [Amount]+[Amount Data B]
     ELSE NULL()
     ENDIF
ELSEIF [Type]="C" THEN 
//3.
     IF [Subtype]="DF" THEN [Amount]-[Amount Data B]
     ELSEIF [Subtype]="CC" THEN [Amount]+[Amount Data B]
     ELSE NULL()
     ENDIF
ELSE
//2.
    [Amount]-[Amount Data B]
ENDIF

Can you test that and let me know if that worked for you please and if you have any questions about the logic behind it?

Thanks,

Angelos