help formatting data based on calculation
hi, thanks for your time.
i would like to do the following:
place a field on a layout that could mask whatever the source field is based on a calculation.
so, i have 10 or so fields on a layout that are possible value 0 - 4.
i want the field to mask all 4s as GREAT!, and just change the source data field.
can this be done?
id rather not create a corresponding field for each of those 10 fields to do the calculation.
thanks in advance