Formatting field-Percent or Currency
I've got a little issue. I'm in the finance world and the boss is always asking for reports, reports, reports! I have a field (calculation) that is extracting information from two other fields. Essentially:
Field A (number) = Percentage
Field B (number)= Currency
Field C(calculation)= If (Is Empty (Field A); Field B; If ( IsEmpty (Field B); Field A))
Ok, works perfectly, except for one thing. In "Field C" I am have difficulty demonstrating the formatting of the extracted information. I need it to show whether it's a Percentage (Field A) or Currency (Field B).
Any ideas? You peeps are always so awesome, thanks for everything!