14 Replies Latest reply: Oct 24, 2013 6:17 PM by Bradley Coyne

# Help in roundoff!

Hi

If the percentage is 69.13% ir 69.65% I want to show it as 69%. Please helpme out to roundoff.

Thanks,
Attitude

• ###### Re: Help in roundoff!

Hi,

This you can do it using chart properties in that u have an option of fixed to, their u can set the number of decimal points u want.

Thanks & Regards,

Rathish

• ###### Help in roundoff!

Hi Rathish

I have already tried that but it is not working as expected. Problem is sales value of a particular month is different when you change the selection.

Thanks,

Attitude

• ###### Help in roundoff!

Hi  At titude

You can use #,##0% format in your chartexpression.

Thanks & Regards,

Rathish

• ###### Re: Help in roundoff!

Hi Rathish

You mean to say something like below? I tried it but it is throwing error(Bad field names). Please do reply!

Num('EXPRESSION',#,##0%)

Thanks,

Attitude

• ###### Re: Help in roundoff!

Hi  At titude,

Num('EXPRESSION',#,##0%,field)

in the expression u can use this format.so that u can it wil remove the decimal points

• ###### Help in roundoff!

What if you try:

Floor(Num('EXPRESSION'))

And set the number format to o decimals in the number format settings on the number tab

?

• ###### Re: Help in roundoff!

Hi Dennis

I have tried it is not working as expected. Please let me know if you have any other suggestion. It is little urgent.

Thanks,

Attitude

• ###### Re: Help in roundoff!

What is the expression you are using?

• ###### Re: Help in roundoff!

Hi Dennis

In  each expression we are calculating the sales for last 14 weeks(week on week). So each expression contains the sales of the week. So when I select week 43 it is show last 14 week sale and when I select week 40 it will show last 15 week sale. So everything is dynamic.

So when I select the week 43 and week 40. Sale for week 35 is 69% when week 43 is selected and sale for week 35 is 70 when week 40 is selected.

Thanks,

Attitude

• ###### Re: Help in roundoff!

So what happens, what is the outcome, when you use:

Floor(Num("FIRSTSELECTION" / "SECONDSELECTION"))

?

• ###### Re: Help in roundoff!

Hi Rathish

What should be passed in place of field? I my case I am using cyclic group. When I passed in the below formula it didn't work. Please let me know if you have any other solution.

Num('EXPRESSION',#,##0%,field)

The exact problem is, for example when I select Week as 45 value it is showing % of profit is as 69% and where are when I select Week 45 for the same week it is showing profit as 70%. The report is very complicated. We are trying to do the week on week sale and month on month sale. Hope my problem is understood.

Thanks,

Attitude

• ###### Re: Help in roundoff!

Hi  At titude,

I mean to say like this

if(COMMONSUBGROUP='GM %' or COMMONSUBGROUP='EBIT%',Num(Sum(Actual),'#,##0%'),Sum(Actual))

Thanks & Regards,

Rathish

• ###### Re: Help in roundoff!

Hi Rathish

In the same report when I select different weeks. For the first selection it is showing percentage as 70% when it's exact percentage is 69.50% and for the second selection it is showing it as 69% when the exact percentage is 69.29%. For both the selection selection of week is same but it showing different value because of the number format.

Hope my requirement are understandable. If not please let me know.

Thanks,

Attitude

• ###### Re: Help in roundoff!

round function?