Formula is returning all zero values CR10

[mabis]

Running on CR10 connecting to a SQL2000 db used for order entry and sales tracking.

We are attempting to track first time new orders from clients. The trigger is manual where an existing user field is being populated. In other words, if a new client buys product for the very first time, the date is added to the field.

The order number table links to the lines in the order where line_user1 field is populated with the data.

This formula worked in the past but now for some reason does not. My sales details for all lines is shown in the report on Da. Db is reserved for the formula @NEWBUSSHOW=

If IsNull({line_dtl.line_user1}) Or
InStr({line_dtl.line_user1}, " ") = 0 Then
Else
{@LINETOTAL}

Simply, if it’s the very first order, the value should show @Linetotal or the line value of he order. Otherwise it should show zero.

In all cases, though user1 field is populated, it is giving me all zero values.

Thank you for any assistance you can provide.

 

[synapsevampire]

And why exactly would we know what @Linetotal is, or care?

The formula used was silly anyway, change it to:

If IsNull({line_dtl.line_user1}) Or
trim({line_dtl.line_user1}) = "" Then
<put something here, your formula had nothing here...>
Else
{@LINETOTAL}

-k

 

[mabis]

At linetotal would be the total of the line on the new order when the formula works properly.

With your changes it now works properly! I guess my version was silly

Thanks for the help.