Hi Folks.
I have a question about query. There is two field in query.Total and Currency. I'd like to multiplication total and currency filelds.I so thing do in query. if currency field is empty , write total to the GTotal.if you help to me I would be very glad.
Thank you
For Example
GTotal:[Total]*[Currency] it is very good working. but I don't want this calculation
GTotal:iif([Currency]is not null;[Total]*[Currency] or iif([Currency] is null; [Total]) it is not working. Query result : -1
Total Currency GTotal
10 * 1.2 = 12
20 * = 20 like.....
I have a question about query. There is two field in query.Total and Currency. I'd like to multiplication total and currency filelds.I so thing do in query. if currency field is empty , write total to the GTotal.if you help to me I would be very glad.
Thank you
For Example
GTotal:[Total]*[Currency] it is very good working. but I don't want this calculation
GTotal:iif([Currency]is not null;[Total]*[Currency] or iif([Currency] is null; [Total]) it is not working. Query result : -1

Total Currency GTotal
10 * 1.2 = 12
20 * = 20 like.....