Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)')