Value from a formula to pull description from a static table

[Juliep]

I am using CR8.5 and am having problems in a report. I have a formula that pulls a string value from an activity table {@LastCode} (this formula locates a value of 999 then pulls next {Activity.PRODUCT_CODE} so is not always the same line number. This formula works just fine, what I need is to be able to use the value that is pulled and use a static table (Gen_Table) and match the formula string value with a matching string in the Gen_Table.CODE and pull the discription field Gen_Table.DESCRIPTION
I have tried: if {@lastCode}={Gen_Table.CODE} then {Gen_Table.DESCRIPTION} which seems logical but doesn't work. Any suggestions

 

[Hattusas]

Maybe adding the token "whileprintingrecords;" will solve your problem.