Skip to Content
0
Former Member
Aug 09, 2016 at 08:50 AM

Script logic for A = B - C

30 Views

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