Calculation Field in BAQ

Yahoo Archive
1
I am having a similar problem in E9. Demand does not calculate correctly in the PartQty, PartBin, and PartWhse tables, so I need to join OrderRel, filter just the Buy Direct demand, and subract it from the Demand in the tables to get the correct number, however the BAQ does not let you calculate on the null field (Demand - My Calculation) - for the null fields it remains null after the calculation. If anyone has figured this out it would be a great help.

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> I tried it and it didnt work the analyze gave me a error
>
>
>
> On Thu, Apr 15, 2010 at 12:32 PM, Steven Gotschall <sgotschall@...>wrote:
>
> >
> >
> > I sometimes have problems using ?(null) in a BAQ calculation. Try comparing
> > to sqrt(-1), which returns a null.
> >
> >
> > On Thu Apr 15th, 2010 1:57 AM EDT efyf_1999 wrote:
> >
> > >Hi All
> > >
> > >I was working with calculation fields in BAQ and tried to do a sort field
> > by combining a few values one of them a date vaule that was sometimes a NULL
> > and so i had to do a IF to eliminate the NULL but it gave me a compile
> > error.
> > >Also i was trying to do a calculation field on another calculation field
> > that was based on a sumarised table and it always gave me back a zero value.
> > >
> > >Can someone help me out with what is acceptable and what not in the
> > calculation field.
> > >
> > >Ephraim Feldman
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
2
Hi All

I was working with calculation fields in BAQ and tried to do a sort field by combining a few values one of them a date vaule that was sometimes a NULL and so i had to do a IF to eliminate the NULL but it gave me a compile error.
Also i was trying to do a calculation field on another calculation field that was based on a sumarised table and it always gave me back a zero value.

Can someone help me out with what is acceptable and what not in the calculation field.

Ephraim Feldman
3
In my experience calculation fields are pretty limited. In 8.03.xxx you
can reference another calculated field from a calculated field. You can
if IF-Then statements as an example..



if labordtl.labortype="I" then if labordtl.indirectcode="PMB" then 0
else if labordtl.indirectcode="STB" then 0 else labordtl.laborhrs else 0



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of efyf_1999
Sent: Thursday, April 15, 2010 12:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculation Field in BAQ





Hi All

I was working with calculation fields in BAQ and tried to do a sort
field by combining a few values one of them a date vaule that was
sometimes a NULL and so i had to do a IF to eliminate the NULL but it
gave me a compile error.
Also i was trying to do a calculation field on another calculation field
that was based on a sumarised table and it always gave me back a zero
value.

Can someone help me out with what is acceptable and what not in the
calculation field.

Ephraim Feldman





[Non-text portions of this message have been removed]
4
I sometimes have problems using ?(null) in a BAQ calculation. Try comparing to sqrt(-1), which returns a null.

On Thu Apr 15th, 2010 1:57 AM EDT efyf_1999 wrote:

>Hi All
>
>I was working with calculation fields in BAQ and tried to do a sort field by combining a few values one of them a date vaule that was sometimes a NULL and so i had to do a IF to eliminate the NULL but it gave me a compile error.
>Also i was trying to do a calculation field on another calculation field that was based on a sumarised table and it always gave me back a zero value.
>
>Can someone help me out with what is acceptable and what not in the calculation field.
>
>Ephraim Feldman
>
5
I tried it and it didnt work the analyze gave me a error



On Thu, Apr 15, 2010 at 12:32 PM, Steven Gotschall <sgotschall@...>wrote:

>
>
> I sometimes have problems using ?(null) in a BAQ calculation. Try comparing
> to sqrt(-1), which returns a null.
>
>
> On Thu Apr 15th, 2010 1:57 AM EDT efyf_1999 wrote:
>
> >Hi All
> >
> >I was working with calculation fields in BAQ and tried to do a sort field
> by combining a few values one of them a date vaule that was sometimes a NULL
> and so i had to do a IF to eliminate the NULL but it gave me a compile
> error.
> >Also i was trying to do a calculation field on another calculation field
> that was based on a sumarised table and it always gave me back a zero value.
> >
> >Can someone help me out with what is acceptable and what not in the
> calculation field.
> >
> >Ephraim Feldman
> >
>
>
>


[Non-text portions of this message have been removed]
6
Ephraim - Do you have Epicor's "General Information on BAQ Calculated
fields", answerbook: 3643ESC? Example 13 and Note 2 may help you.


Dale Dalton





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ephraim Feldman
Sent: Friday, April 16, 2010 12:44 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Calculation Field in BAQ

I tried it and it didnt work the analyze gave me a error



On Thu, Apr 15, 2010 at 12:32 PM, Steven Gotschall
<sgotschall@...>wrote:

>
>
> I sometimes have problems using ?(null) in a BAQ calculation. Try
comparing
> to sqrt(-1), which returns a null.
>
>
> On Thu Apr 15th, 2010 1:57 AM EDT efyf_1999 wrote:
>
> >Hi All
> >
> >I was working with calculation fields in BAQ and tried to do a sort field
> by combining a few values one of them a date vaule that was sometimes a
NULL
> and so i had to do a IF to eliminate the NULL but it gave me a compile
> error.
> >Also i was trying to do a calculation field on another calculation field
> that was based on a sumarised table and it always gave me back a zero
value.
> >
> >Can someone help me out with what is acceptable and what not in the
> calculation field.
> >
> >Ephraim Feldman
> >
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
7
Hi Dale

I don't have that book and I would really appreciate if you can give me a link to download or email it to me

Thanks
Ephraim
Ephraim Feldman

-----Original Message-----
From: "Dale Dalton" <daled@...>
Date: Fri, 16 Apr 2010 08:23:26
To: <vantage@yahoogroups.com>
Subject: RE: [Vantage] Calculation Field in BAQ

Ephraim - Do you have Epicor's "General Information on BAQ Calculated
fields", answerbook: 3643ESC? Example 13 and Note 2 may help you.


Dale Dalton





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ephraim Feldman
Sent: Friday, April 16, 2010 12:44 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Calculation Field in BAQ

I tried it and it didnt work the analyze gave me a error



On Thu, Apr 15, 2010 at 12:32 PM, Steven Gotschall
<sgotschall@...>wrote:

>
>
> I sometimes have problems using ?(null) in a BAQ calculation. Try
comparing
> to sqrt(-1), which returns a null.
>
>
> On Thu Apr 15th, 2010 1:57 AM EDT efyf_1999 wrote:
>
> >Hi All
> >
> >I was working with calculation fields in BAQ and tried to do a sort field
> by combining a few values one of them a date vaule that was sometimes a
NULL
> and so i had to do a IF to eliminate the NULL but it gave me a compile
> error.
> >Also i was trying to do a calculation field on another calculation field
> that was based on a sumarised table and it always gave me back a zero
value.
> >
> >Can someone help me out with what is acceptable and what not in the
> calculation field.
> >
> >Ephraim Feldman
> >
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links






[Non-text portions of this message have been removed]