cancel
Showing results for 
Search instead for 
Did you mean: 

previous function issue

former_member366557
Participant
0 Kudos

hi expert,

my apology for sending you a lot of my problem because iam a new with this application.. please help me to know more about this..

thank you.

my issue is why when i am using previous function there is no value in first group

please see image below- on the first details on the first group there is a blank space here that i think it should be true

script:

If ({OINV.NumAtCard}) = previous({OINV.NumAtCard}) then 0 else {OINV.U_20STD}

thank you

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Silent,

The first record has no previous record.

Try:

If onfirstrecord then

{OINV.U_20STD}

Else if {OINV.NumAtCard} = Previous({OINV.NumAtCard}) then 0

Else {OINV.NumAtCard}

-Abhilash

former_member366557
Participant
0 Kudos

sir thank you for your response,, but stll same output..

regards

silent

former_member205840
Active Contributor
0 Kudos

Hi Silent,

Go in the the formula / script , on top the window you will see a drop down with 'Exceptions for NULLs' click on that and change it to 'Default Values for Nulls'

Thanks,

Sastry