Skip to Content
0
Former Member
Jul 15, 2015 at 08:24 PM

Setting decimal place on a report field

34 Views

Hello,

I am using Crystal 10 and I have embedded sub-reports that contain fields/formulas that display 6 decimal places on my report. I've attempted to use the TOTEXT({OEORDD.UNITPRICE},2) formula but am having issues. Here is what my formula does now

// Price by Quantity and No Detail Discount

// Print the Unit Price

//TOTEXT({OEORDD.UNITPRICE}, {OEORDD.UNITPRCDEC})

TOTEXT({OEORDD.UNITPRICE},2)

ELSE

IF {OEORDD.QTYORDERED} <> 0 THEN

ToText((({OEORDD.EXTINVMISC} - {OEORDD.INVDISC}) /

{OEORDD.QTYORDERED}), {OEORDD.UNITPRCDEC})

ELSE

""

ELSE

""

Currently all output is :48.000000 I'd like it to only show 2 decimal places = 48.00