Formatting Average in Aggregate Field

[Woolf]

I have added averages to my report via the AGGREGATE field. I would like it to only have 2 decimal points (it currently is showing many decimal points). However, I do not see anywhere to modify the formatting for the AVERAGE function. Can someone point me to where I can change the formatting?

Thanks.

[kpcollier]

You should be able to do it with the 'Formatting...' button on the bottom right of the Wizard. Click that button, select Custom (or Localization) and enter in the format type you want. You can adjust digits after decimal.

 

 

 

[Woolf]

The FORMATTING button is grayed out and is not clickable. I assumed that was normal.

The option to modify the formatting is only clickable if I select FORMULA. But I do not want to use a formula. I want to use the AVERAGE function.

I have looked in the LOCALIZATION and also the STYLES sections to see if there is a way to modify the formatting there for AVERAGES and I do not see where this is possible. Maybe I am missing it?

This feels like it should be easy and I am making it hard. 

[kpcollier]

14 minutes ago, Woolf said:

The FORMATTING button is grayed out and is not clickable.

Yeah, I just noticed that. It seems when you include a Formula field and an Integer field together, the formatting field greys out. 

I'm not too sure how else you'd be able to do it, besides typing out the average formula yourself in the Formula section and then formatting it. 

I'll try to play around with it a little. 

[Woolf]

SOLVED! 

I realized I had combined NUMBER fields with INTEGER fields in a single AGGREGATE field. When I split them up onto their own AGGREGATE fields then Caspio let me format them.

Thanks for your help!