Hi everyone,
I have a little difficulty in basic calculation to be done in script logic. Request help on this.
I need to perform A = B - C.
I have written a code
*WHEN ACCOUNT
*IS B
*REC(EXPRESSION = %VALUE% - [ACCOUNT].[C], ACCOUNT = A)
*END WHEN
In this code when B does not have any value, A does not get calculated. THus, I added below part of code to above code.
*WHEN ACCOUNT
*IS C
*REC(EXPRESSION = [ACCOUNT].[B] - %VALUE%, ACCOUNT = A)
*END WHEN
Now, this works fine until either B or C (only any one) has value.
If both B as well as C has value, it is calculating twice and answer I am getting is double of what is expected.
I am really sorry if this question has been repeated or seem to be silly, but require solution for this.
Regards,
Swetha