Dual Function is not working

[Anonymous]

Hi all,

I used dual function like following

=Dual(Channel & '(' & num(Sum(Profitability)/1000,'#.#0%')& ')',num(Sum(Profitability)/1000,'$#,##0 K;($#,##0 K)'))

i got only (175695080.00%) value but i want % value as well as second expression value

Please help me

thanks,

[Peter_Cammaert]

The dual() function can be used to fill both the numerical part and the string representation of a value/field in QV memory. You cannot use it to concatenate strings, it that is what you want.

Use this to provide custom formatting for your expression results:

=Only(Channel) & '(' & num(Sum(Profitability)/1000,'#.#0%')& ')' & ' ' & num(Sum(Profitability)/1000,'$#,##0 K;($#,##0 K)')