percentage difference

[Monkey820]

Hi!

I need to show the difference between 2 values in percentage.

I have been away from crystal for a while and am feeling lost.

Any help appreciated.

Thanks

 

[lbass]

Between two fields? Two group summaries? You should provide more info initially. Syntax would be:

if {table.field1} <> 0 then
({table.field2}-{table.field1}) % {table.field1}

-LB

 

[Monkey820]

I need to know the percentage {Table.Avgcost} difference from {Table.Stdcost} per itemnumber and if the percentage is over 10% to change the font color to red.

This is a detail line item.

 

[Monkey820]

and .... I need to format the value
ex: 10%

 

[lbass]

So did you try my suggestion for the display? All you have to do then is click on the % icon in the toolbar. Then for the color, go to format field->font->color->x+2 and enter:

if currentfieldvalue > 10 then crred else crnocolor

-LB

 

[Monkey820]

Perfect! Thank you! Thank you!!