Formatting pattern integer numbers

[ratnalein]

Hallo everyone,

I have a query item in my query subject.  This query item is an attribute from type Int32.  In Query Studio, this query item appears:

Number of population
---------------------------
3948573
84930900
4940
43
83980
....

Is there any possibilities to format the pattern to be:

Number of population
---------------------------
3.948 573
84.930.900
4.940
43
83.980
....

Thank you for your help.

Regards,

Ratna

[blom0344]

Use the 'thousands seperator' by setting this to 'yes'.

[ratnalein]

Hallo blom0344,

thank you very much, it works ;)

Mhh.. maybe one more question.  As I described before, this is a query item, which is an Attribute.  I have set the Regular Aggregate as Count, which is correct.

I would like to have it summed at the end of the line:

Number of Population
---------------------------
1.000
34.699.500
22
23.843
----------------
34.724.365

Is this possible?  As I said, the regular aggregate of this query item is COUNT.

Thank you for your help.

Regards,

Ratna

[blom0344]

Any reason why you would want to 'count' the 'number of population' ?  I guess you could use a  total([number of population] for report) and use that is summary, but I may be missing your point..

[ratnalein]

Hallo blom0344,

thank you for your quick reply.  In report, I think that would be a good idea to use total.  Actually I was meaning this sum aggregation for Query Studio:

Number of Population with house (this is my fact)            Number of population
---------------------------------------------------------------------------------------------------
2000                                                                                  3000
5000                                                                                  6000
1000                                                                                  2000
---------------------------------------------------------------------------------------------------
8000                                                                                 

The aggregation of my fact column is automatically done from framework manager.  But the number of population is a query item, which is definied as COUNT in the regular aggregation.  In fact, it is a ATTRIBUTE in the physical table.  It would be nice, if I can total this column.  But I think, this is not possible in Query Studio?

Number of Population with house (this is my fact)            Number of population
---------------------------------------------------------------------------------------------------
2000                                                                                  3000
5000                                                                                  6000
1000                                                                                  2000
---------------------------------------------------------------------------------------------------
8000                                                                                 11000

Thank you for your help.

Regards,

Ratna
   

[blom0344]

I'm no QS expert, but I fail to see how you could apply a custom aggregate on an attribute the way you want..