How to Flag a Field When compared to another Field

[bstafford21]

Hello,

I am using Crystal 9 and pulling data from Magic for a SO & WO report.

I now have this working properly to show all Open WO & SO with the Order Qty and Inventory Qty showing correctly.

What I need help on is a way to flag or highlight the Inventory Qty when it is below the Sales Order Qty.

I tried using the Highlight feature but does not allow me to compare the 2 fields.

What is the best way to flag this or highlight it so it is detected by someone reviewing the report?

 

[synapsevampire]

You should explain how you arrive at the Qtys, and why you cannot use them in the highlighting feature, saying you cannot isn't very descriptive.

Assuming that you're using a Running Total or a Summary function to arrive at these, you might reference the Running Total or formula in the X 2 next to the background color if your intent is to highlight the row or a field, as in:

If {#MyRunningTotal1} < {#MyRunningTotal2} then
CRYellow
else
CRWhite

-k

 

[bstafford21]

I am pulling the Qty Values from a Magic Database as I said and there are no formulas at all.

I have 8 columns with the following information sorted By Date Group.

Due Date
Sales Order No.
Part No.
Work Order No.
Work Order Qty
Box Qty
Inventory Qty
Sales Order Qty

Each item is from a database in Magic and I just need to flag the Inventory Qty value when when it falls below the Sales Qty value.

Thanks

Bill

 

[kskid]

Right click on Inventory Qty -> Format Field...

Under the font tab color, click on the X+2 and enter the following

if {Inventory Qty} < {Sales Order Qty} then
CrRed
Else
CrBlack

Cheers,

-LW

 

[bstafford21]

Excellent, the formula works great, thanks for the help.

Learning more each day on formulas.

Great forum and great people.

Thanks again LW

Cheerio

Bill