Need help in validating the script logic

[Former Member]

Hi,

Currently we are working on NW BPC 10.0

I need a help in modifying my script logic. Below code is my current script logic.

My requirement is:

From the above screen shot,

if TOT_COMP_YTD<FUT_LIMIT then TOT_COMP*FUT_RATE should be done

if TOT_COMP_YTD>FUT_LIMIT then subtract current month FUT_LIMIT with previous month TOT_COMP_YTD(only   for first occurrence of                                                                                                                              TOT_COMP_YTD>FUT_LIMIT, remaining all should be ZEROs)

I have changed my script as below and executed in UJKT, but I am getting some validation error.

Can anybody help me how to achieve this.

Regards

Anitha

[Former Member · Accepted solution]

It is working.. I forgot to put braces.

[Former Member]

Hi Anitha,

I have to say your logic is to complicated in the *REC(). It will be very hard to find out the root cause. Please do some pre-analyze for some simple key word ot see which part is the error message reporting for.

Best Regards,
Arjen

[Former Member]

Hi Arjen,

I have tried.

The error is because of the statement

  ([HR_ACCT].[FUT_LIMIT],[TIME].[%TIME%])-([HR_ACCT].[TOT_COMP_YTD],TMVL(-1,%TIME%))

Once I removed the HR_ACCT it is validating successfully.

Any idea how to achieve this?

Regards

Anitha