Forum Discussion

RyMarcattilio-M's avatar
RyMarcattilio-M
Qrew Member
4 months ago

Limiting the number of significant digits in a summarized field

Hi all,

I've got a simple report that summarizes city population data by total, min, max, average, etc. All works well. But when I include a summary field with standard deviation in it, I get a ton of extra significant digits. How do I get rid of those? 

Thanks!

Ry



------------------------------
Ry Marcattilio-McCracken
------------------------------

4 Replies

  • In the field settings you can change the display value to a # of digits under the display section



    ------------------------------
    Chayce Duncan
    ------------------------------
    • RyMarcattilio-M's avatar
      RyMarcattilio-M
      Qrew Member

      Thanks Chayce - I did this for the regular table fields (appreciate it), but there's no option to do this for a calculated field being created for a report, like standard deviation, right?



      ------------------------------
      Ry Marcattilio-McCracken
      ------------------------------
      • ChayceDuncan's avatar
        ChayceDuncan
        Qrew Captain

        Ah now I see - you're using the summary report and using the stnd deviation there. Unfortunately that particular method doesn't have rounding settings - but what you could try is the Summary formulas down below. If you define a summary variable and create your stnd deviation field - you can then reference it in the formula build and just copy / round it there to be used. 



        ------------------------------
        Chayce Duncan
        ------------------------------