Summary table in BAQ by date range

Yahoo Archive
1
Interesting, I'll give it a try
Â
Thanks


________________________________
From: Karen Schoenung <kschoenung@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, April 23, 2012 12:32 PM
Subject: RE: [Vantage] Summary table in BAQ by date range


Â
TOTAL(if formula, else)

For example, Month1Total = TOTAL (if date in month1 then invoice total, else 0)
For example, Month2Total = TOTAL (if date in month2 then invoice total, else 0)
Above is only an example of the expression of the code, not actual code...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, April 20, 2012 10:09 AM
To: Vantage User Group
Subject: [Vantage] Summary table in BAQ by date range

I used a summary table in a BAQ to display total amount from the invoice header, but I want the invoice amounts to total by month or fiscal period. Anyone know of a way to do that without having to put it into a crystal report?

[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]
2
I used a summary table in a BAQ to display total amount from the invoice header, but I want the invoice amounts to total by month or fiscal period. Anyone know of a way to do that without having to put it into a crystal report?

[Non-text portions of this message have been removed]
3
I don't remeber how this is exactly done been a while since messed with BAQs but I think you may be able to mess with a calculated field in the display area of the designer to at least tweak your date results. I did some along the lines of skipping weekend displays with that once.

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> I used a summary table in a BAQ to display total amount from the invoice header, but I want the invoice amounts to total by month or fiscal period. Anyone know of a way to do that without having to put it into a crystal report?
>
> [Non-text portions of this message have been removed]
>
4
TOTAL(if formula, else)

For example, Month1Total = TOTAL (if date in month1 then invoice total, else 0)
For example, Month2Total = TOTAL (if date in month2 then invoice total, else 0)
Above is only an example of the expression of the code, not actual code...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, April 20, 2012 10:09 AM
To: Vantage User Group
Subject: [Vantage] Summary table in BAQ by date range



I used a summary table in a BAQ to display total amount from the invoice header, but I want the invoice amounts to total by month or fiscal period. Anyone know of a way to do that without having to put it into a crystal report?

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



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