[SPAM] RE: Report Builder Calculation Help Please

Yahoo Archive
1
Another ole timer!! Thanks Todd!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, January 08, 2010 10:30 AM
To: vantage@yahoogroups.com
Subject: [SPAM] [Vantage] RE: Report Builder Calculation Help Please



Sort of jammed at the moment to work this out in details but I think I
would start with TODAY() - 182 or there abouts to get a rough date. If
you are not being real exact about things like weekends and such anyway
this should be adequate for analysis purposes. Otherwise to be exact
there are some ways to build the number of days in each month into a
CASE structure and add any six of them in succession starting from an an
index position based on current month number, adding the days up and
subtracting from TODAY(). At least these are the approaches I would
start with depending on the level of accuracy needed.

If it CAN be done in RB I've probably done it. All the new 8x. and 9
people just don't know what they're missing. ;)

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Darren Mann
Sent: Friday, January 08, 2010 9:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Report Builder Calculation Help Please

Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY()) <= 6, DATE(STRING(MONTH(TODAY()) + 6) + "/" +
STRING(DAY(TODAY())) + "/" + STRING(YEAR(TODAY()) - 1)),
DATE(STRING(MONTH(TODAY()) - 6) + "/" + STRING(DAY(TODAY())) + "/" +
STRING(YEAR (TODAY()))))

Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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

[Non-text portions of this message have been removed]
2
Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY()) <= 6, DATE(STRING(MONTH(TODAY()) + 6) + "/" +
STRING(DAY(TODAY())) + "/" + STRING(YEAR(TODAY()) - 1)),
DATE(STRING(MONTH(TODAY()) - 6) + "/" + STRING(DAY(TODAY())) + "/" +
STRING(YEAR (TODAY()))))


Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222


[Non-text portions of this message have been removed]
3
Is this a BAQ report and what version of Vantager are you on? Progress or SQL?

I don't know if this will help, but when I have to compare a Vantage date to a date somewhere in the future or past on a BAQ report or Dashboard, I create a calculated field in my BAQ. For example, I have one where I need to check if the date is less then 30 days in the future, so my calculated field in the BAQ is:

Date(Integer(Today) + 30)



________________________________
From: Darren Mann <dmann@...>
To: vantage@yahoogroups.com
Sent: Fri, January 8, 2010 10:02:41 AM
Subject: [Vantage] Report Builder Calculation Help Please

Â
Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY( )) <= 6, DATE(STRING( MONTH(TODAY( )) + 6) + "/" +
STRING(DAY(TODAY( ))) + "/" + STRING(YEAR( TODAY()) - 1)),
DATE(STRING( MONTH(TODAY( )) - 6) + "/" + STRING(DAY(TODAY( ))) + "/" +
STRING(YEAR (TODAY()))))


Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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







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

Vantage 5.2
Report Builder

I will try that approach and see. Thanks for the reply.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steven Gotschall
Sent: Friday, January 08, 2010 9:34 AM
To: vantage@yahoogroups.com
Subject: [SPAM] Re: [Vantage] Report Builder Calculation Help Please



Is this a BAQ report and what version of Vantager are you on? Progress
or SQL?

I don't know if this will help, but when I have to compare a Vantage
date to a date somewhere in the future or past on a BAQ report or
Dashboard, I create a calculated field in my BAQ. For example, I have
one where I need to check if the date is less then 30 days in the
future, so my calculated field in the BAQ is:

Date(Integer(Today) + 30)

________________________________
From: Darren Mann <dmann@...
<mailto:dmann%40millerproductsco.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Fri, January 8, 2010 10:02:41 AM
Subject: [Vantage] Report Builder Calculation Help Please


Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY( )) <= 6, DATE(STRING( MONTH(TODAY( )) + 6) + "/" +
STRING(DAY(TODAY( ))) + "/" + STRING(YEAR( TODAY()) - 1)),
DATE(STRING( MONTH(TODAY( )) - 6) + "/" + STRING(DAY(TODAY( ))) + "/" +
STRING(YEAR (TODAY()))))

Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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

[Non-text portions of this message have been removed]
5
We are on 8.03, so that just about exhausts my capability to help.




________________________________
From: Darren Mann <dmann@...>
To: vantage@yahoogroups.com
Sent: Fri, January 8, 2010 10:41:47 AM
Subject: RE: [SPAM] Re: [Vantage] Report Builder Calculation Help Please

Â
Sorry

Vantage 5.2
Report Builder

I will try that approach and see. Thanks for the reply.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Steven Gotschall
Sent: Friday, January 08, 2010 9:34 AM
To: vantage@yahoogroups .com
Subject: [SPAM] Re: [Vantage] Report Builder Calculation Help Please

Is this a BAQ report and what version of Vantager are you on? Progress
or SQL?

I don't know if this will help, but when I have to compare a Vantage
date to a date somewhere in the future or past on a BAQ report or
Dashboard, I create a calculated field in my BAQ. For example, I have
one where I need to check if the date is less then 30 days in the
future, so my calculated field in the BAQ is:

Date(Integer( Today) + 30)

____________ _________ _________ __
From: Darren Mann <dmann@millerproduct sco.com
<mailto:dmann% 40millerproducts co.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Fri, January 8, 2010 10:02:41 AM
Subject: [Vantage] Report Builder Calculation Help Please

Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY( )) <= 6, DATE(STRING( MONTH(TODAY( )) + 6) + "/" +
STRING(DAY(TODAY( ))) + "/" + STRING(YEAR( TODAY()) - 1)),
DATE(STRING( MONTH(TODAY( )) - 6) + "/" + STRING(DAY(TODAY( ))) + "/" +
STRING(YEAR (TODAY()))))

Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

[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]
6
LOL I'm an ole timer. Thank you for trying.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steven Gotschall
Sent: Friday, January 08, 2010 9:58 AM
To: vantage@yahoogroups.com
Subject: [SPAM] Re: [SPAM] Re: [Vantage] Report Builder Calculation Help
Please



We are on 8.03, so that just about exhausts my capability to help.

________________________________
From: Darren Mann <dmann@...
<mailto:dmann%40millerproductsco.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Fri, January 8, 2010 10:41:47 AM
Subject: RE: [SPAM] Re: [Vantage] Report Builder Calculation Help Please


Sorry

Vantage 5.2
Report Builder

I will try that approach and see. Thanks for the reply.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Steven Gotschall
Sent: Friday, January 08, 2010 9:34 AM
To: vantage@yahoogroups .com
Subject: [SPAM] Re: [Vantage] Report Builder Calculation Help Please

Is this a BAQ report and what version of Vantager are you on? Progress
or SQL?

I don't know if this will help, but when I have to compare a Vantage
date to a date somewhere in the future or past on a BAQ report or
Dashboard, I create a calculated field in my BAQ. For example, I have
one where I need to check if the date is less then 30 days in the
future, so my calculated field in the BAQ is:

Date(Integer( Today) + 30)

____________ _________ _________ __
From: Darren Mann <dmann@millerproduct sco.com
<mailto:dmann% 40millerproducts co.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Fri, January 8, 2010 10:02:41 AM
Subject: [Vantage] Report Builder Calculation Help Please

Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY( )) <= 6, DATE(STRING( MONTH(TODAY( )) + 6) + "/" +
STRING(DAY(TODAY( ))) + "/" + STRING(YEAR( TODAY()) - 1)),
DATE(STRING( MONTH(TODAY( )) - 6) + "/" + STRING(DAY(TODAY( ))) + "/" +
STRING(YEAR (TODAY()))))

Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

[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]
7
From one ole timer to another...try this



Today() - 180 as a calculated field. Then, select all pur-stk
transactions that are greater than or equal to this calculated field.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Friday, January 08, 2010 8:07 AM
To: vantage@yahoogroups.com
Subject: RE: [SPAM] Re: [SPAM] Re: [Vantage] Report Builder Calculation
Help Please





LOL I'm an ole timer. Thank you for trying.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Steven Gotschall
Sent: Friday, January 08, 2010 9:58 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [SPAM] Re: [SPAM] Re: [Vantage] Report Builder Calculation Help
Please

We are on 8.03, so that just about exhausts my capability to help.

________________________________
From: Darren Mann <dmann@...
<mailto:dmann%40millerproductsco.com>
<mailto:dmann%40millerproductsco.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Fri, January 8, 2010 10:41:47 AM
Subject: RE: [SPAM] Re: [Vantage] Report Builder Calculation Help Please

Sorry

Vantage 5.2
Report Builder

I will try that approach and see. Thanks for the reply.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Steven Gotschall
Sent: Friday, January 08, 2010 9:34 AM
To: vantage@yahoogroups .com
Subject: [SPAM] Re: [Vantage] Report Builder Calculation Help Please

Is this a BAQ report and what version of Vantager are you on? Progress
or SQL?

I don't know if this will help, but when I have to compare a Vantage
date to a date somewhere in the future or past on a BAQ report or
Dashboard, I create a calculated field in my BAQ. For example, I have
one where I need to check if the date is less then 30 days in the
future, so my calculated field in the BAQ is:

Date(Integer( Today) + 30)

____________ _________ _________ __
From: Darren Mann <dmann@millerproduct sco.com
<mailto:dmann% 40millerproducts co.com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Fri, January 8, 2010 10:02:41 AM
Subject: [Vantage] Report Builder Calculation Help Please

Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY( )) <= 6, DATE(STRING( MONTH(TODAY( )) + 6) + "/" +
STRING(DAY(TODAY( ))) + "/" + STRING(YEAR( TODAY()) - 1)),
DATE(STRING( MONTH(TODAY( )) - 6) + "/" + STRING(DAY(TODAY( ))) + "/" +
STRING(YEAR (TODAY()))))

Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

[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]




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________



[Non-text portions of this message have been removed]
8
Sort of jammed at the moment to work this out in details but I think I would start with TODAY() - 182 or there abouts to get a rough date. If you are not being real exact about things like weekends and such anyway this should be adequate for analysis purposes. Otherwise to be exact there are some ways to build the number of days in each month into a CASE structure and add any six of them in succession starting from an an index position based on current month number, adding the days up and subtracting from TODAY(). At least these are the approaches I would start with depending on the level of accuracy needed.

If it CAN be done in RB I've probably done it. All the new 8x. and 9 people just don't know what they're missing. ;)

-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Darren Mann
Sent: Friday, January 08, 2010 9:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder Calculation Help Please



Happy New Year folks!!

I am trying to create a purchasing report that includes the past 6
months of PUR-STK transactions from the Part Tran file. I can not seem
to get a calculation to work that would create a date 6 months previous
to the Today() function. Can anyone think of a viable solution to pull
filter these records to just the past 6 months from the date the report
is printed??

Here's what I had:

IIF(MONTH(TODAY()) <= 6, DATE(STRING(MONTH(TODAY()) + 6) + "/" +
STRING(DAY(TODAY())) + "/" + STRING(YEAR(TODAY()) - 1)),
DATE(STRING(MONTH(TODAY()) - 6) + "/" + STRING(DAY(TODAY())) + "/" +
STRING(YEAR (TODAY()))))


Thanks for any assistance!! Have a GREAT day.

Darren Mann
IT Manager/Purchasing
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

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





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