Permanently deleted user
Currently when using a calculation field the results field does not match the format for the 'number' operator ie no comma is inserted. For example
Field 1 entry is 1,000.00. Field 2 entry is 1,000.00. if you create the calculation Field 1 + Field 2 the results field shows: 2000.00 (no comma). This looks strange when the fields are itemised on a submission and could lead to mistakes especially when using large numbers. If you select Currency format in the Calculations field it does insert the comma so it would be helpful if this worksd for Number also.
0
Comments
Please sign in to leave a comment.
Hi Sufia,
Thanks so much for the feedback! This is an interesting one - I ended up learning some things about numbers and commas and decimals along the way. You're right that it would make sense for the calculation to take the same formatting as the fields it's calculating, including commas. Interestingly, commas only show up if you allow for decimals (which I didn't know). I'm going to ask around about this a little, because I'm curious about why it works like that.
Thanks!
It would be good to have this as a select-able field formatting option rather than hard coding it one way or the other as some custom PDFs that may be dynamically applying custom formatting might be adversely impacted by a blanket change like this.
Yeah, it also gets complicated with some location stuff, like if you're in a country that uses commas as decimals. So it would be interesting to set all of that on an App or a field basis and standardize across users.
Agreed. A global App-level setting with the ability to set fields to inherit that from the app (or not and then choose what you want per field on a field by field basis) would be awesome. Then that same settings framework could be used as a development stepping stone to make almost all settings act the same way... expand it out later to Account > Department or Group > Folder > App > Field ... then you could do some global configuration of your preferences one time and have everything downhill from there inherit the global settings unless you go in and manually change a setting at a lower level, etc. Pie in the sky.