Another Crystal Question

Yahoo Archive
1
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
in advance!

John Meier
Nutro Corp.
2
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
in advance!

John Meier
Nutro Corp.


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable 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: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
3
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
> in advance!
>
> John Meier
> Nutro Corp.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
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:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]