Hi Sreejith,
You will find the field OrderAmt which is the total order value. You can sort the fields in a table alphabetically to find what you are looking for. Look around the Order... fields and the Total... fields.
The syntax will depend on what you are trying to do in the calculated field. Send what you have and we can see if we can help...
- Neil
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sreejith Jaganathan
Sent: Wednesday, 21 November 2012 7:13 PM
To: Vantage Group
Subject: [Vantage] Not able to see a field while creating BAQ
Good Afternoon
I need to use the field TotalOrder from the
table OrderHed but I dont see this field in the display in BAQ
Please do let me know where to find this field.
I am also trying to use the CALC field but every time I
get the message that the syntax is not correct.
Please specify what is the correct syntax to create a
calc field.
Regards
[Non-text portions of this message have been removed]
Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
P Please consider our shared environment before printing this communication.
[Non-text portions of this message have been removed]
You will find the field OrderAmt which is the total order value. You can sort the fields in a table alphabetically to find what you are looking for. Look around the Order... fields and the Total... fields.
The syntax will depend on what you are trying to do in the calculated field. Send what you have and we can see if we can help...
- Neil
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sreejith Jaganathan
Sent: Wednesday, 21 November 2012 7:13 PM
To: Vantage Group
Subject: [Vantage] Not able to see a field while creating BAQ
Good Afternoon
I need to use the field TotalOrder from the
table OrderHed but I dont see this field in the display in BAQ
Please do let me know where to find this field.
I am also trying to use the CALC field but every time I
get the message that the syntax is not correct.
Please specify what is the correct syntax to create a
calc field.
Regards
[Non-text portions of this message have been removed]
Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
P Please consider our shared environment before printing this communication.
[Non-text portions of this message have been removed]