I would like to custom format numbers in a webi report so that numbers that are greater than 1 will display the percent as 5% (no decimal) but numbers less than one will display with the decimal 0.45%?
is it possible with custom format or do I need to just write the formula?