Value Formating

[#1]

Hello,

Is it possible to format values of a particular field as Currency and Percentage based on specific rules?

As an example, in the attached file, the discount column in QV should display a Currency format for Product A and B, but it should display % format for Product C.

The format is determined based on Product.

Thanks,

[sunny_talwar]

You can do something like this:

If(Match(Product, 'A', 'B'), Num(Expression, '$#,##0'), Num(Expression, '##%'))