BAQ calculated field syntax error

Yahoo Archive
1
Just a guess but the first field is listed as "InvDtl" instead of "InvcDtl"?



Regards,



Michael



Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please immediately notify me by
telephone and permanently delete the original and any copy of any email and
any printout thereof.




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
stanchmura
Sent: Wednesday, February 27, 2008 6:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ calculated field syntax error



I was writing a BAQ to summarize job costs which requires a calulated
field to add material, labor, subcontract and burden cost.
Unfortunately, I kept getting a syntax error in field message, but of
course no indication of what about the syntax was incorrect. So I
referred to the program help screens and found that the example was
exactly the calculated field I was trying to write. Great! Except
that copying and pasting it and even retyping it still returns the
same syntax error. Has any one encountered this? Or can anyone tell
me what the error might be for a formula like this?

Here is the example copied from Help:

Example #1: (+ InvDtl.LbrUnitCost + InvcDtl.BurUnitCost +
InvcDtl.MtlBurUnitCost + InvcDtl.MtlUnitCost + InvcDtl.SubUnitCost) *
InvcDtl.SellingShipQty





[Non-text portions of this message have been removed]
2
I was writing a BAQ to summarize job costs which requires a calulated
field to add material, labor, subcontract and burden cost.
Unfortunately, I kept getting a syntax error in field message, but of
course no indication of what about the syntax was incorrect. So I
referred to the program help screens and found that the example was
exactly the calculated field I was trying to write. Great! Except
that copying and pasting it and even retyping it still returns the
same syntax error. Has any one encountered this? Or can anyone tell
me what the error might be for a formula like this?

Here is the example copied from Help:

Example #1: (+ InvDtl.LbrUnitCost + InvcDtl.BurUnitCost +
InvcDtl.MtlBurUnitCost + InvcDtl.MtlUnitCost + InvcDtl.SubUnitCost) *
InvcDtl.SellingShipQty