colour text if less than percentage 1

[tonyvee1973]

Hi Guys
Have a report in Crystal X1 and a bit stuck.
Have 2 x fields '@physical' which shows physical stock and '@free' which shows free stock.
What i'm trying to do is colour the text red in @free when it is less than 20% of the '@physical' else leave it black.

I've tried the below formula by right clicking the '@loc free' formula, format field, font, then inserting this formukla into the formula box which relates to colour. Needless to say it doesnt work

if {@loc free} <20% {@Physical} then crRed
else DefaultAttribute;

Any assistance would be appreciated

 

[fisheromacse]

try this minor change to your logic:

if {@loc free} < ({@Physical} * 0.20) then crRed
else DefaultAttribute;

 

[tonyvee1973]

Thanks fisheromacse - worked like a charm!