Formating Text

[ThabisoPaul]

Hi Guys,

I want to format my text to show only 2 decimal places

=num(num(num(num(Num(sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered), '#,##0.','.',',')

-

Num(sum({<Report_MONTH={'$(=month(max(MonthName(Report_Date))))'}>} Abandoned+[Transfered]), '#,##0.','.',','))

/

Num(sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered), '#,##0.','.',','),0 & '%'))) *100

[olivetwist · Accepted solution]

it looks to me like you have got overkill with formatting.

do your equation in full and apply formatting around it like below:

num(
(sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered)
-sum({<Report_MONTH={'$(=month(max(MonthName(Report_Date))))'}>} Abandoned+[Transfered]))
/
sum({<Report_MonthT={'$(=Month(date(MonthStart(today()))))'}>} Offered)
,'#.##')

[ThabisoPaul]

Hi,

I Re -structured the script and removed all the Formats and i am currently
using one and its working fine.

Thanks.