topic CONVERT TO TEXT BOX in App Development

CONVERT TO TEXT BOX

shravanveer — Wed, 08 Jun 2022 06:16:43 GMT

HI,

Given Table Convert to TEXT BOX Like " 1=8.46%"

MayilVahanan — Wed, 08 Jun 2022 07:17:52 GMT

Try like below

=Concat(Distinct Aggr(Category&'='&Sum(LineSalesAmount), Category), chr(13))

for sorting:

Concat(Distinct Aggr(Category&'='&Sum(LineSalesAmount), Category), chr(13), Aggr(Sum(LineSalesAmount), [Category]))

shravanveer — Wed, 08 Jun 2022 11:56:41 GMT

but how to get the value in percentage ?

MayilVahanan — Wed, 08 Jun 2022 12:44:43 GMT

Instead of using, "Sum(LineSalesAmount)", u can use ur percentage expression.

like num(urexpression, '#,##0.##%')