Min BAQ command

Yahoo Archive
1
If I try to summarise the table I receive the message that main tables cannot be summarised.

The below formula is for the whole BAQ isn't it? I'm just rying to do a calcualted field.

FOR EACH Record:
ACCUMULATE Record.DateVal (MAXIMUM).
END.

DISPLAY (ACCUM MAXIMUM Record.DateVal ).

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hey people,
>
> I'm building a BAQ and need the minimum of a date. I have tried the following:
>
> MINIMUM(OrderHed.RequestDate)
>
> Format: 99/99/9999
> Date Type: Date
>
> I have also tried
>
> MIN(OrderHed.RequestDate)
>
> and left the format as blank. However, the BAQ does not run saying there is an error with the calculated field.
>
> Any ideas?
>
> Michael
>
2
Hey people,

I'm building a BAQ and need the minimum of a date. I have tried the following:

MINIMUM(OrderHed.RequestDate)

Format: 99/99/9999
Date Type: Date

I have also tried

MIN(OrderHed.RequestDate)

and left the format as blank. However, the BAQ does not run saying there is an error with the calculated field.

Any ideas?

Michael
3
What I do is to order my BAQ by the date and then use the First or Last clause in the Table Relations of the BAQ. If there is another way to do this, I would be interested in finding out. I've never been able to get the Maximum or Minimum aggregate phrase to work in a calculated field of a BAQ.




________________________________
From: "michael.hutcheson@..." <michael.hutcheson@...>
To: vantage@yahoogroups.com
Sent: Wed, February 3, 2010 8:59:31 AM
Subject: [Vantage] Min BAQ command

Â
Hey people,

I'm building a BAQ and need the minimum of a date. I have tried the following:

MINIMUM(OrderHed. RequestDate)

Format: 99/99/9999
Date Type: Date

I have also tried

MIN(OrderHed. RequestDate)

and left the format as blank. However, the BAQ does not run saying there is an error with the calculated field.

Any ideas?

Michael







[Non-text portions of this message have been removed]
4
Your syntax is incorrect.

You are showing the MAXIMUM function which returns the largest value of two or more input parameters.

The syntax you want is:

FOR EACH Record:
ACCUMULATE Record.DateVal (MAXIMUM).
END.

DISPLAY (ACCUM MAXIMUM Record.DateVal ).

Thank you,

Justin C. Muller
President, Managing Partner
Velocity Development Group, LLC
jmuller@...<mailto:jmuller@...>
www.velocitydev.com<http://www.velocitydev.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Wednesday, February 03, 2010 9:18 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Min BAQ command



What I do is to order my BAQ by the date and then use the First or Last clause in the Table Relations of the BAQ. If there is another way to do this, I would be interested in finding out. I've never been able to get the Maximum or Minimum aggregate phrase to work in a calculated field of a BAQ.

________________________________
From: "michael.hutcheson@...<mailto:michael.hutcheson%40rocketmail.com>" <michael.hutcheson@...<mailto:michael.hutcheson%40rocketmail.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Wed, February 3, 2010 8:59:31 AM
Subject: [Vantage] Min BAQ command


Hey people,

I'm building a BAQ and need the minimum of a date. I have tried the following:

MINIMUM(OrderHed. RequestDate)

Format: 99/99/9999
Date Type: Date

I have also tried

MIN(OrderHed. RequestDate)

and left the format as blank. However, the BAQ does not run saying there is an error with the calculated field.

Any ideas?

Michael

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



[Non-text portions of this message have been removed]
5
Michael, may I assume that the table you're using this MINIMUM function
on is a *summarized* table in the BAQ? It must be summarized.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Wednesday, February 03, 2010 9:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Min BAQ command

Hey people,

I'm building a BAQ and need the minimum of a date. I have tried the
following:

MINIMUM(OrderHed.RequestDate)

Format: 99/99/9999
Date Type: Date

I have also tried

MIN(OrderHed.RequestDate)

and left the format as blank. However, the BAQ does not run saying
there is an error with the calculated field.

Any ideas?

Michael



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

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