Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
If the percentage is 69.13% ir 69.65% I want to show it as 69%. Please helpme out to roundoff.
Thanks,
Attitude
What is the expression you are using?
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
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
So what happens, what is the outcome, when you use:
Floor(Num("FIRSTSELECTION" / "SECONDSELECTION"))
?
round function?