Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I need to carry forward the "Approve2 Dt " based on company code and claim no.
For e.g if company code is 1 and Claim no is 123 and the date has to be repeated for all the same combination.
Also, attached the sample data.
I have tried the following code:
If(("Claim No." = previous("Claim No.") and "Company Code"=previous("Company Code"))
and len("Approve2 Dt") = 0, Peek('NewValue'), "Approve2 Dt") as NewValue
But coudn't help me to get the expected result.
Please help me to resolve this issue.
Regards,
Kavita
try this:
If([Claim No.] = peek([Claim No.], -1) and [Company Code]=peek([Company Code], -1) and len([Approve2 Dt]) = 0, Peek([NewValue], -1), [Approve2 Dt]) as NewValue
Hello,
Thank You for the solution. But its not working: