Numeric problem with the field "Year"

[#1]

Hello everyone,

I am creating a bar chart which displays the occupants ratio of total employees percentage by the year.

I used the field "Year" as a dimension, and the expression is the calculated percentage already done in the data base.

As you can see below, the chart displays the year with lot of zeros:

How can i set the Year as integer??

Thanks

[maxgro]

in number tab

or in the load script

floor(Year) as Year

[MarcoWedel]

or a dimension like

=Num(Year,'0')

[PrashantSangle]

or try

Subfield(Year,'.',1)

or

mid(Year,1,4)

or

left(Year,4)

regards

[engishfaque]

Deara Rodrigo,

Kindly find attached file, I hope you are looking for that one solution.

Kind regards,

Ishfaque Ahmed