Help with a formula in CR 8.5

[ccclsi]

Hi,

I have a report where i would like to have 1 column that will look at 3 fields, (part.fabricated, part.purchased, and part.detail_only) these fields have either a "Y" or "N". What i would like to do is have a formula that says "if part.fabricated = "Y" then "F" else part.purchased ="Y" then "P", else part.detail_only = "Y" then D,.

Is this doable?

 

[IanWaterman]

YOu write a formula exactly like you have defined.

However, Crystal does not like NULLS if any of those filed can be null the whole formula will fail.

YOu could create 3 test formula first

@Fab
If isnull(part.fabricated) then 'N' else part.fabricated

Repeat for other fileds and then use these formula in your If .. then..else formula.

Insert that into your detail line.

Ian

 

[lbass]

I'm wondering what you expect the result to be--you realize that once one of the fields meets the criterion, the remaining fields will not be evaluated.

-LB