http://forums.visokio.com/discussions/tagged/formula/feed.rss Mon, 30 Oct 17 12:12:59 -0400 Tagged with formula - Visokio Forums en-CA http://forums.visokio.com/discussion/3269/thousands-separator-formatting-commas-in-numbers Tue, 10 Oct 2017 05:49:51 -0400 Cheyam 3269@/discussions
Is there a way to stop Omniscope from putting commas in every single number field interpreted by every block in the application?

- I have an R block in which output_data contains a number of integer columns. When they are retrieved from the R dataframe and processed in Omni theyre all get given commas. There are too many fields of differing types to go in and manually remove the commas from each integer field.
- When you have integers over three digits and try merge with another field without commas in the numbers the ones with commas do not merge with the ones without commas.
- When I have this fairly simple formula:'=COUNTIF(A:A,A' & (CURRENTROW()+ 2) & ')' in a field organizer I am returned with =COUNTIF(A:A,A1,071). (I know its sloppy to inject excel formulae like this but bear with me)

If I asked colleagues of mine they would agree that the frustrations and issues caused by this feature are multiples of this. Is there any way this can be addressed? Commas in numbers is a display feature and shouldnt exist in the datamanager. A suitable solution would be to stop the application putting commas in all formulae by default.

Thank you,
Chey]]>