6 Replies Latest reply on Sep 6, 2019 9:47 AM by Bryce Larsen

    Format in formula - parameter & calculated field

    Wes Patton

      I have a parameter option for the user to select the metric.  Things like outstanding balance, delinquency rate, etc.  Problem is that I want to have the numbers display as appropriate.  It's easy enough to get like dollars in millions through calculated prefix and suffix.  The problem I'm running into is showing the percentage metrics with decimals but the whole number metrics with no decimals.

       

      Any thoughts?  This would be a quick fixed formula in Excel.  What do I do?