|
-
In a field of your column in your query add my_result:iif([liftingdevicetotal] = 0,([preusetotal] + [traveltotal] + [deposittotal] + [stackingtotal] + [parkingtotal]) / 100 * 1,
([preusetotal] + [traveltotal] + [deposittotal] + [stackingtotal] + [parkingtotal] + [liftingdevicetotal]) / 105 * 1)
Change my_result to a suitable otherwise the query will add Expr1: to the field.
Allan
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|