comma instead of dot

[Anonymous]

In my all reports on on Access Point, I am having problem by getting commas instead of  dot.

Example: 123,45,88 instead of   123,45.88 (I also need Thousand seperator)

Reports work fine on my local machine.

Any changes need to apply on Access point side ?

Thanks

[Anonymous]

In addition to sunindia - you can specify your default settings:

SET ThousandSep=',';

SET DecimalSep='.';

[sunny_talwar]

Hahahaha msolomov I had to delete my response because I was not sure if what I said would work or not. .

Best,

Sunny

[Anonymous]

Anyway, I'm not changing my post

[sunny_talwar]

I feel what you have specified in itself would fix his problem. So my response would just have been redundant even if it was to work.

Best,

Sunny

[Anonymous]

I have these only

Thanks

[Anonymous]

Hi Sunny

I appreciate your time on Sunday morning.

For decimal I have variable vDecimal with values 0, 0.0, 0.00, 0.000, 0.0000, 0.00000), so because of this I cant LOAD values as you suggested here

      Num((Sum({$<SCENARIO_ID = , QUARTER = {99}>} ATTRIBUTE_VALUE)/1000000),vDec)
And as I said EXPORT work fine on local PC but not on Access Point

What can be done?

Thanks

[Anonymous]

I see you have some strange format of the data.  Assuming it was a typo, and you mean 123,456,88, this will work:

=num(left('123,456,88', index('123,456,88',',',-1)-1) + subfield('123,456,88',',',-1)/100, '###,###.00')

[Anonymous]

Hi Michael

Data format also good, it is numbers only and it's work absolutely fine on local PC but not on Access Point.

I have millions of row and all populated with this format. In this decimal also variable. Something wrong at Access point side.

[Anonymous]

This is really strange...  Maybe you have some unusual format settings on the QV Server box (?)  It is in control Panel, Region and Language, Additional settings.  There you have number formats.

If nothing helps, maybe you can upload an example that works tis way, I'll try on my server on Monday.