BAQ - Aggregate Command - Total()

Yahoo Archive
1
I don't believe that will work. I usually just setup a counter aggregate it
all manually in these kind of situations.

DEFINE VARIABLE total AS DECIMAL.

FOR EACH ttTable WHERE ttTable.Field = 1:
total = total + ttTable.Field.
END.

Or something similar.

On Mon, Jun 4, 2012 at 4:36 PM, Winter, Patrick <pjw@...>wrote:

> **
>
>
> All,
>
> Total(expression)
>
> Calculates the total of all the values of the numeric database field.
>
> Calculated field call 'May' set to decimal.
>
> Total(If Month(Add-interval( PartTran.TranDate , -1, 'month')) = 5
>
> Then PartTran.TranQty else 0)
>
> Check Syntax = OK
>
> My logic looks good for the test but if I setup for different months
> they all just give grand totals.
>
> So am I correct in assuming that you can't nest an 'if' statement in the
> TOTAL aggregate command.
>
> Anyone go down this road before.
>
> Seemed logical to me.
>
> Patrick Winter
>
> [Non-text portions of this message have been removed]
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


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



Total(expression)

Calculates the total of all the values of the numeric database field.



Calculated field call 'May' set to decimal.



Total(If Month(Add-interval( PartTran.TranDate , -1, 'month')) = 5

Then PartTran.TranQty else 0)



Check Syntax = OK



My logic looks good for the test but if I setup for different months
they all just give grand totals.

So am I correct in assuming that you can't nest an 'if' statement in the
TOTAL aggregate command.

Anyone go down this road before.

Seemed logical to me.





Patrick Winter





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