2 Replies Latest reply on Oct 2, 2018 12:05 PM by Michael Ye

    Show % or String in Calculation

    Chad Clauson

      I have a worksheet on my dashboard which will return the effectiveness % each day. However, the database does not run on Mondays so there will not be anything displayed. I can simply modify the calculation and write "else 0" to display 0 but I rather display a string saying "Job not ran". I know I can't return both float or string value in a calculated field. How can I get around this? I know I could use the str() function for my calculation but that  will usually return a decimal with many places rather than a % with 1 place as desired. What about overlapping sheets?