Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All ,
Iam using a text box to display the difference between current year and previous year and it is working fine , what i want to know is i want to display the % symbol infront of the symbol ,
The text box has the following expression :=(Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))
Give me any suggestion
Thanks in advance
You can surround your expression with num( <here your expression as argument 1>, <here the numberformat as argument 2>)
number format (when it is a percentage with 1 decimal can be ###,#
Hi Roberto
Thanks for ur reply , can u plz alter my expression , iam facing difficulty in understanding it , can u plz
....
In Number Tab, Please check show in Percent Option
You can use like this also
='%' & (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))
=num( (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100)) ,'####,#')
Assuming that , is your decimal separator.
If your decimal separator is a . (dot) then replace ####,# with ####.#
Celambarasan Adhimulam's option however seems a bit easier by the way.
Thanks Celambarasan
I copied and pasted the expression u gave , but its showing error , can u plz help me out
I believe what Celambarasan suggest like put in front of the expression
='%' & (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))
Use:
num(Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))),'$#,##0%;($#,##0%)')