Same field on two tables, merge into one field on report 1

[CrystalUser90]

Hi there,

I am trying to select data from two different tables. Both tables have a field called 'Posting Group', one table is the sales table and the other is the returns table.

How do I set up a common field on the report that will select the value from table 'sales', and then if there is no values in 'sales' select the value from the same named field in table 'returns'.

Thanks in advance!

 

[fisheromacse]

I think you could create a formula something like:
{@FormulaName}
If isnull({sales.FieldName})=TRUE
then {returns.FieldName}
else {sales.FieldName}

 

[CrystalUser90]

Thank you so much fisheromacse!!

I've been trying variations of that for days and couldn't get it right! That worked!