Formula Blank Title 82899

Yahoo Archive
1
If you use your query to find the last invoice, can you filter by the year (I just use the fiscal year field) in your dashboard or Crystal or whatever you're using to display the information?

--- In vantage@yahoogroups.com, Jonathan Lang <lsbestinc@...> wrote:
>
> I tried that. The problem is that I want to eliminate the customers who ordered in 2009 and keep the ones that ordered prior to 2009. When I do a formula based off of {Invoice.Date} it just eliminates the "Records" not the "Customer".
>
> --- On Thu, 9/17/09, Kirstin <kirstin.brandt@...> wrote:
>
>
> From: Kirstin <kirstin.brandt@...>
> Subject: [Vantage] Re: Formula
> To: vantage@yahoogroups.com
> Date: Thursday, September 17, 2009, 10:37 AM
>
>
> Â
>
>
>
> It looks like you're trying to create some kind of Inactive Customer report? Can you link to invchead using last and then filter for the year <> 2009?
>
> --- In vantage@yahoogroups .com, Jonathan Lang <lsbestinc@ ..> wrote:
> >
> > I need a formula that does the following:
> > Â
> > Exclude {Customer} if Year({InvoiceDate} ) = 2009Â
> > Â
> > Can anyone help with this one?
> > Â
> > Jonathan LangÂ
> > Oil Rite Corporation
> > Sr. Network Administrator
> > Ph: (920) 682-6173 Ext: 126
> > Fax: (920) 682-7699
> > Â
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I need a formula that does the following:
Â
Exclude {Customer} if Year({InvoiceDate}) = 2009Â
Â
Can anyone help with this one?
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â




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

I'm assuming you don't want to include the invoice value if Year(InvDate) = 2009.


Something like this should push you in the right direction:

If Year({Invoice_Date}) = 2009 then 0 else {Invoice_Total}

Put that in a formula called "xInvoiceTotal" or something like that and then use xInvoiceTotal as your summed displayed value on your report.

Make sense?


Vic



Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jonathan Lang
Sent: Thursday, September 17, 2009 9:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Formula

I need a formula that does the following:
Â
Exclude {Customer} if Year({InvoiceDate}) = 2009Â
Â
Can anyone help with this one?
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â




[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
4
It looks like you're trying to create some kind of Inactive Customer report? Can you link to invchead using last and then filter for the year <> 2009?

--- In vantage@yahoogroups.com, Jonathan Lang <lsbestinc@...> wrote:
>
> I need a formula that does the following:
> Â
> Exclude {Customer} if Year({InvoiceDate}) = 2009Â
> Â
> Can anyone help with this one?
> Â
> Jonathan LangÂ
> Oil Rite Corporation
> Sr. Network Administrator
> Ph: (920) 682-6173 Ext: 126
> Fax: (920) 682-7699
> Â
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
I tried that. The problem is that I want to eliminate the customers who ordered in 2009 and keep the ones that ordered prior to 2009. When I do a formula based off of {Invoice.Date} it just eliminates the "Records" not the "Customer".

--- On Thu, 9/17/09, Kirstin <kirstin.brandt@...> wrote:


From: Kirstin <kirstin.brandt@...>
Subject: [Vantage] Re: Formula
To: vantage@yahoogroups.com
Date: Thursday, September 17, 2009, 10:37 AM


Â



It looks like you're trying to create some kind of Inactive Customer report? Can you link to invchead using last and then filter for the year <> 2009?

--- In vantage@yahoogroups .com, Jonathan Lang <lsbestinc@. ..> wrote:
>
> I need a formula that does the following:
> Â
> Exclude {Customer} if Year({InvoiceDate} ) = 2009Â
> Â
> Can anyone help with this one?
> Â
> Jonathan LangÂ
> Oil Rite Corporation
> Sr. Network Administrator
> Ph: (920) 682-6173 Ext: 126
> Fax: (920) 682-7699
> Â
>
>
>
>
> [Non-text portions of this message have been removed]
>



















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