Would you still expect this to work even if the first calculated field was based on a summarised table? Thanks.
--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> It worked for me.
>
> But I discovered over time that the first calculated field must be created before the second if not it doesn't work.
>
> Ephraim Feldman
>
> -----Original Message-----
> From: "Brian Roberts" <broberts@...>
> Sender: vantage@yahoogroups.com
> Date: Thu, 19 Jul 2012 15:00:31
> To: <vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BAQ Calculated Field
>
> Worked for me in 9.05.607B for a couple simple ones, don't remember
> doing anything special.
>
> First calc field is: ShipDtl.OurInventoryShipQty + ShipDtl.OurJobShipQty
>
> Second is: OrderRel.OurReqQty - OurShipQty
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Len Hartka
> Sent: Thursday, July 19, 2012 2:48 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BAQ Calculated Field
>
>
>
>
>
> Good Day Brian:
>
> What version are you on
>
> I have tried using a calc-field in another calc-field and it did not
> work. Have you actually done it?
>
> Maybe works sometimes? Depend on files, fields; calculation, etc.
>
>
> Sun is on 9.05.605 since 10/2/11 - SQL-Unidata- 64 bit
> Live on 9.05.601B since 11/29/10
> Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
>
>
>
> len.hartka@... <mailto:len.hartka%40sunautomation.com>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Brian Roberts
> Sent: Thursday, July 19, 2012 2:31 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] BAQ Calculated Field
>
> Not possible, the BAQ calculated field syntax is a single expression.
> However, you can define one calculated field to hold part of a complex
> expression, then use that in a second calculated field.
>
> Thanks,
>
> Brian.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of tkoch77
> Sent: Thursday, July 19, 2012 12:08 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] BAQ Calculated Field
>
> Is it not possible to define variables within a calculated field? I'm
> trying this simple declaration with no luck. First time attempting this.
>
> Define Variable x As Integer NO-UNDO.
>
> TIA,
>
> -Ted
>
> [Non-text portions of this message have been removed]
>
> This e-mail and any attachments may contain proprietary and/or
> confidential information. If you are not the intended recipient, please
> notify the sender immediately by reply e-mail or at 410-472-2900 and
> then delete the message without using, disseminating, or copying this
> message or any portion thereof. With e-mail communications you are urged
> to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>