Week Number to fixed number

[suzey]

Hi Everyone,

I want to display the week number, which is no problem, I can get the week number using the datepart formula.

But this returns a number with decimals ie: 34.00

Is there a way to make this formula just the whole number?

I've tried various functions, fix, truncate, round with no joy, has anyone got any ideas?


Thank you


Sue

 

[lbass]

Right click on the number->format field->number and select
-1123.

-LB

 

[suzey]

Thanks lbass,

I was hoping to do this all in a formula, 'cos I want to use this field in a graph.

At the minute if I format the field using the formatting options it is not carried onto the graph, and I've searched through all the graph options and cannot find anywhere to format the number on the graph.

So I was hoping I could do all the formatting in the formula, any ideas?

Thank you


Sue

 

[lbass]

You could change the weeknumber formula to:

totext(datepart("ww",{table.date}),"00")

This will sort correctly, but will show single numbers as 01,02, etc.

-LB

 

[suzey]

Thanks lbass, that worked

......I had it stuck in my mind that it had to be a number to get the chart to display them in the right order.

Thanks again



Sue