I am on 905.700C. I am doing a dashboard.
What I am doing now to work around the issue is a data directive on PartDtl that sums PartDtl.Quantity into PartQty.Number01.
Greg Payne
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, January 28, 2013 1:48 PM
To: Vantage
Subject: Re: [Vantage] Re: I need a Null Value to show Zero in BAQ custom calculated field
What version are you on?
Are you doing this for a report? Or a Dashboard?
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
What I am doing now to work around the issue is a data directive on PartDtl that sums PartDtl.Quantity into PartQty.Number01.
Greg Payne
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, January 28, 2013 1:48 PM
To: Vantage
Subject: Re: [Vantage] Re: I need a Null Value to show Zero in BAQ custom calculated field
What version are you on?
Are you doing this for a report? Or a Dashboard?
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Mon, Jan 28, 2013 at 11:53 AM, Greg Payne <gpayne@...>wrote:
> **
>
>
> I can get it to pass syntax, but throws an error at the sql server. I
> am looking for Total quantity on order for a Part. I was getting from
> Total(PartDtl.Quantity), but if there are none on order this is null
> and the rest of the calculation is not done.
>
> How else is there to get this info?
>
> Thanks
>
> Greg Payne
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Monday, January 28, 2013 8:49 AM
> To: Vantage
> Subject: Re: [Vantage] Re: I need a Null Value to show Zero in BAQ
> custom calculated field
>
> Try
> Total(ISNULL(FIELD,0))
> Not sure of the equivalent syntax although you almost got it.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> http://www.linkedin.com/in/josecgomez>
> http://www.facebook.com/josegomez>
> http://www.google.com/profiles/jose.gomez>
> http://www.twitter.com/joc85>
> http://www.josecgomez.com/professional-resume/>
> http://www.josecgomez.com/feed/>
> http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jan 28, 2013 at 8:36 AM, gpayne_e9 gpayne@...>
> wrote:
>
> > **
>
> >
> >
> >
> > I need to do this on an aggregate of partdtl. is there a way to make
> > the null value zero in this case.
> >
> > I tried this, but is returns an error from sql.
> >
> > if isnull ( total( PartDtl.Quantity )) then 0 else Total (
> > partDtl.Quantity )
> >
> > Thanks
> >
> > Greg Payne
> >
> >
> > --- In vantage@yahoogroups.com, Joe Rojas wrote:
> > >
> > > Hi there,
> > >
> > >
> > >
> > > Couldn't you do something like:
> > >
> > > If isnull( ) then
> > >
> > > 0
> > >
> > > Else
> >
> > >
> > >
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of redrhyno13
> > > Sent: Wednesday, January 02, 2013 4:31 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] I need a Null Value to show Zero in BAQ custom
> > > calculated field
> > >
> > >
> > >
> > >
> > >
> > > Welcome 2013!
> > >
> > > I have a BAQ that is pulling a field that is sometimes null.
> > > (Decimal
> > > field) I want to create a custom field that if the field is null
> > > it will display Zero so I can do a sum of the fields to show a total.
> > > It doesn't display correctly with the null...
> > > A normal IFNULL( ,0) doesn't work.
> >
> > >
> > > Regards,
> > >
> > > Chris Wineinger
> > > ERP Specialist
> > > Interior Systems Inc.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Joe Rojas | Director of Information Technology | Mats Inc
> > > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > > jrojas@... | www.matsinc.com Ask us about our clean, green and
> > beautiful matting and flooring
> >
> > >
> > >
> > > This message is intended only for the individual named. If you are
> > > not
> > the named addressee you should not disseminate, distribute or copy
> > this e-mail. Please notify the sender immediately by e-mail if you
> > have received this e-mail by mistake. Please note that any views or
> > opinions presented in this email are solely those of the author and
> > do not necessarily represent those of the company.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
> [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
>
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including
> attachments, is privileged and confidential. It is intended only for
> the exclusive use of the addressee. If the reader of this message is
> not the intended recipient, or the employee or agent responsible for
> delivering it to the intended recipient, you are hereby notified that
> any dissemination, distribution or copying of this communication is
> strictly prohibited. If you have received this communication in error,
> please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in
> the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10.
> Export of this material is restricted by the Arms Export Control Act
> (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons
> without prior approval form the U.S. Department of State."
>
>
>
[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
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."