format

[TomBond77]

Hi experts

I have this formula but the formatting is not working for 0.00% and  '#''###.','.',''''))

Any ideas where the problem is?

(
if (InternrapportPercentageRow.IsPercentageRow,
num(
(Sum({<Konto.Id={'2450'}, [SEM_BCS account]={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / -1000)
+ Sum({<Konto.Id={'2450'}, [SEM_BCS account]-={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / 1000)
- Sum({<Konto.Id-={'2450'}>} amount / 1000)
)

/

(TOP(
Sum( {<Konto.Id={'2450'}, [SEM_BCS account]={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / -1000)
+ Sum( {<Konto.Id={'2450'}, [SEM_BCS account]-={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / 1000)
- Sum( {<Konto.Id-={'2450'}>} amount / 1000))),'0.00%')

//else
,
num(round(money(
Sum({<Konto.Id={'2450'}, [SEM_BCS account]={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / -1000)
+ Sum({<Konto.Id={'2450'}, [SEM_BCS account]-={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / 1000)
-Sum({<Konto.Id-={'2450'}>} amount / 1000))), '#''###.','.',''''))
)

-

(
if (InternrapportPercentageRow.IsPercentageRow,
num(
(
Sum({<Date.Month=, $(vSetBudget)>}budget / -1000 )
)

/

top(Sum({<Date.Month=, $(vSetBudget)>}budget / -1000 )),'0.00%')
, //else
num(
round(money(Sum({<Date.Month=, $(vSetBudget)>}budget / -1000) )), '#''###.','.',''''))
)

[vinieme12]

if (InternrapportPercentageRow.IsPercentageRow,
//Then
num(
(
(
Sum({<Konto.Id={'2450'}, [SEM_BCS account]={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / -1000)
+ Sum({<Konto.Id={'2450'}, [SEM_BCS account]-={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / 1000)
- Sum({<Konto.Id-={'2450'}>} amount / 1000)
)
/
(
TOP((
Sum( {<Konto.Id={'2450'}, [SEM_BCS account]={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / -1000)
+ Sum( {<Konto.Id={'2450'}, [SEM_BCS account]-={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / 1000)
- Sum( {<Konto.Id-={'2450'}>} amount / 1000)))
)
)
-
(
Sum({<Date.Month=, $(vSetBudget)>}budget / -1000 )
/
top(
Sum({<Date.Month=, $(vSetBudget)>}budget / -1000 )
)
)

,'0.00%')

//else
,
num(
(round(
(
Sum({<Konto.Id={'2450'}, [SEM_BCS account]={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / -1000)
+ Sum({<Konto.Id={'2450'}, [SEM_BCS account]-={'311000 Invoiced sales DDPS + 3rd parties','312009 Invoiced sal. solution and products I/C'}>} amount / 1000)
-Sum({<Konto.Id-={'2450'}>} amount / 1000)
)
-
Sum({<Date.Month=, $(vSetBudget)>}budget / -1000)
)
)
, '#,###')
)