want % to be a new line. I want the % to be below the number.

[Sxbbb]

I use code

Dual((sum(If(Aggr(Sum(Number),OrderNo)>=10,1,0)))&' ('& Num (sum(If(Aggr(Sum(Number),OrderNo)>=10,1,0))/(count(DISTINCT OrderNo)) ,
'#,##0.00%') &')', sum(If(Aggr(Sum(Number),OrderNo)>=10,1,0)) )

 results

I want % to be a new line. I want the % to be below the number.

[ajaykakkar93]

hi,
can try the below code, 
Use chr(10) for next line and add % 

Dual(

(sum(If(Aggr(Sum(Number),OrderNo)>=10,1,0)))

&' ('&

Num (

(sum(If(Aggr(Sum(Number),OrderNo)>=10,1,0))

/

(count(DISTINCT OrderNo))) *100 ,

'#,##0.00')

&')'&chr(10)&'%'

, sum(If(Aggr(Sum(Number),OrderNo)>=10,1,0)) )

[Sxbbb]

Can I change the scale to %?

[ajaykakkar93]

raw code
'('&Num(    (expression/expression) * 100 ,  '#,##0.00') &')'&chr(10)&'%'

[Sxbbb]

it can't be done