problem with sum plz help 1

[Durango122]

Hi Folks
cr 9.0
ms sql
i have a report that contains a gr call contact_id
here is a sample of colums

contact id 529 sma total
jim 5 2 7
i create a formula for each of the 529,sma,total
something like this
--------------------------------------------
@529_S
//529
if {TRANSACTION_HISTORY.POSTING_DATE} in Date(year({?End_Date}),1,1) to
Date(Year({?End_Date}),Month({?End_Date}),day({?End_Date}))
and
{FUNDS.PRODUCT_TYPE} = "529" and
{TRANSACTION_HISTORY.TRADE_CLASS} = "S"
then
round({TRANSACTION_HISTORY.GROSS_AMOUNT})
else
0
----------------------------------
and so one for the other
and i created a summary base on the contact_id
sum(@529_S,contact_id)
------------------------------
that works fine
and for my total
i got this formula
@YTD_TOT_S
{@YTD_MF_S}+{@YTD_529_S}
and created a summary like this

sum(YTD_TOT_S,contact_id)
thats fine

now there asking to have a parameter call Amount
and i made it and have 0.00 as default no link to table

They want to be abel to enter an amount let say 10,000
and pass this value to the sum(YTD_TOT_S,contact_id)
i tried this
and get error
sum(YTD_TOT_S,contact_id) = {?Amount}

how can i get the paramter to get the amount base on
sum(YTD_TOT_S,contact_id)
with is my summary of {@YTD_MF_S}+{@YTD_529_S}
thanks






Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

You should be placing:

sum(YTD_TOT_S,contact_id) = {?Amount}

in report->selection formula->GROUP. If you are still having problems, you should show the content of the error message.

-LB

 

[Durango122]

Hi -LB
thanks for the replied.
i also have a paramter that has 3 selection
Purchase
Red
Net

in the group selection i place this
if
{?FlowType} = 'Purchase' then (sum({@YTD_TOT_S},{CONTACT.CONTACT_ID})) >= {?Amount}
else if
{?FlowType} = 'Red' then (sum({@YTD_TOT_R},{CONTACT.CONTACT_ID})) >= {?Amount}
else if
{?FlowType} = 'Net' then (sum({@YTD_TOT_NET},{CONTACT.CONTACT_ID})) >= {?Amount}

i trid it but for some reason when i do red wich is a number with a minus (-)
ex; -500
i get lots of 0 and some -500 i should only get the -500 and up base on the red selection


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

Note that 0 is "and up" from a negative number, so I don't know what you mean. If you want to disregard the negative sign, then use:

else if
{?FlowType} = 'Red' then abs(sum({@YTD_TOT_R},{CONTACT.CONTACT_ID})) >= {?Amount}

-LB

 

[Durango122]

thanks a million -LB

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40