Numberformat problem

[beck_bakytbek]

Hi Folks,

i have a situation,

my textbox with numbers does look like (see attached screenshot)

if i open my app in desktop: my numbers do look like: 166,5M (with comma)

but if i open my app in server: my number do look like : 166.5M (without comma)

i know this is a format problem.

what is the best way to resolve it?

Thanks a lot

Beck

[sunny_talwar]

What is the expression you have used for this particular KPI?

[beck_bakytbek]

Hi Sunny,

my expression does look like:

Sum({<DatenTyp={'Personalkosten','Reisekosten'}>}Anzahl)

Thanks a lot for your help und time

Beck

[kkkumar82]

Why don't you format yourself using Num(Sum({<DatenTyp={'Personalkosten','Reisekosten'}>}Anzahl), '$#,##0.00')

for eg like above

[beck_bakytbek]

Hi Kiran,

first of all, thanks a lot for taking the time to help me,

to situation: i tried and i uses this expression: {'Personalkosten','Reisekosten'}>}Anzahl), '$#,##0.00')

but nothing has changed i still have the same problem.

Thanks a lot

Beck

[kkkumar82]

How are you checking your file into Server , once check this variable in edit script in your server file and desktop file

SET DecimalSep='.';

[beck_bakytbek]

Hi Kiran,

what do you meean with: SET DecimalSep = ' ';

if you see my attached example, some textobjects show me my numbers with correct format, although i use the same way of creating of variable, i understand that server do not recognize my numbers in correct format.

Do you have an example?

thanks a lot

[kkkumar82]

it is a system variable which you can see in the data load editor of your app,.