Formula for parameter help

[jlr123]

I have the following formula parameter however it is not giving me the correct results. The parameter should be UDF New_Sales_Rep if it is not blank else InvoiceHistoryHeader.Salesperson

if isnull ({AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}) or {AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}="" then
{AR_InvoiceHistoryHeader.SalespersonNo} else {AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}


Your help is much appreciated.

 

[kray4660]

First off do you have "Default Values for Nulls" selected in the Formula Workshop? Second have you tried using the following code "if len({AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP})= 0 then
{AR_InvoiceHistoryHeader.SalespersonNo} else {AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}"

 

[jlr123]

I thought len is for totext? The data is text already. And your formula does not work. Thanks anyway.

 

[jlr123]

My original formula was correct. I did not have the tables linked properly.

No need for any additional assistance on this issue.

Thanks!

 

[jlr123]

I now need to add another condition to the formula.

My need is based on this statement -If there is nothing in the UDF field then Header field, and if there is nothing in the UDF field and the Header field does not equal to Customer field then Customer field.

Before adding the additional condition, my formula is working as the following: but I need the added condition.
if isnull ({AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}) or {AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}="" then
{AR_InvoiceHistoryHeader.SalespersonNo} else {AR_InvoiceHistoryHeader.UDF_NEW_SALES_REP}

Added condition to this statement would be the following:

If {AR_InvoiceHistoryHeader.SalespersonNo} <> {AR_Customer.SalespersonNo}
THEN {AR_Customer.SalespersonNo}

Thanks for your assistance.

 

[jlr123]

I was trying to make this more complicated that necessary.

Don't really need the AR_HistoryHeader.SalespersonNo field.

No additional assistance needed.
Thanks.