# Another Crystal Question

Using CR 7.0, trying to calculate a total line cost for a quoted
item. Using the following: quoteqty.QUANTITY * quoteqty.UNITPRICE.
When attempting to create a formula, it returns a message that a
number or currency amount is required for the quantity. In Vantage,
the field is a decimal type. Any ideas why this won't work? Thanks

John Meier
Nutro Corp.
John,
The field quoteqty.QUANTITY is exported by vantage as a string rather than a number. You can modify your formula to convert the quantity to a number as follows:
tonumber({quoteqty.QUANTITY})*{quoteqty.UNITPRICE}

Should work for you.

Troy Funte
Liberty Electronics

----- Original Message -----
From: johnmeierbp
To: vantage@yahoogroups.com
Sent: Thursday, December 06, 2001 4:09 PM
Subject: [Vantage] Another Crystal Question

Using CR 7.0, trying to calculate a total line cost for a quoted
item. Using the following: quoteqty.QUANTITY * quoteqty.UNITPRICE.
When attempting to create a formula, it returns a message that a
number or currency amount is required for the quantity. In Vantage,
the field is a decimal type. Any ideas why this won't work? Thanks

John Meier
Nutro Corp.

(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/links

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

Worked as you said. Thanks!!

John

--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> John,
> The field quoteqty.QUANTITY is exported by vantage as a string
rather than a number. You can modify your formula to convert the
quantity to a number as follows:
> tonumber({quoteqty.QUANTITY})*{quoteqty.UNITPRICE}
>
> Should work for you.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: johnmeierbp
> To: vantage@y...
> Sent: Thursday, December 06, 2001 4:09 PM
> Subject: [Vantage] Another Crystal Question
>
>
> Using CR 7.0, trying to calculate a total line cost for a quoted
> item. Using the following: quoteqty.QUANTITY *
quoteqty.UNITPRICE.
> When attempting to create a formula, it returns a message that a
> number or currency amount is required for the quantity. In
Vantage,
> the field is a decimal type. Any ideas why this won't work?
Thanks
>
> John Meier
> Nutro Corp.
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
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: