Report Builder extended price field

Yahoo Archive
1
You need two seperate functions. First, create a
function (using fx button) that multiplies qty x unit $,
and call it something like "extended". Second, use the
aggregate (Sum) functions to create a field that will
total the new "extended" field.

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: <KRGENT@...>
To: <vantage@egroups.com>
Sent: Monday, September 25, 2000 10:11 AM
Subject: [Vantage] Report Builder extended price field


>
> Could anyone assist me in the process in adding the total extended value
of a
> mfg. part report which multiples the quantity field x the parts unit price
> and then gives me a total of the complete column. This is a basic report I
> need to compare my inventory value from my our old system compared to
Vantage
> when we go live. I have all the appropriate fields we require for the
report,
> I just need to add this field with the total sum and can not figure out
how
> to go about in creating this inserted field ?
>
> Thank You,
>
> Gary Waldman
> KRG Enterprises
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>
2
Could anyone assist me in the process in adding the total extended value of a
mfg. part report which multiples the quantity field x the parts unit price
and then gives me a total of the complete column. This is a basic report I
need to compare my inventory value from my our old system compared to Vantage
when we go live. I have all the appropriate fields we require for the report,
I just need to add this field with the total sum and can not figure out how
to go about in creating this inserted field ?

Thank You,

Gary Waldman
KRG Enterprises