topic Convert value to string in App Development

Convert value to string

Anonymous — Sat, 20 Oct 2018 04:17:41 GMT

I want to make this set analysis expression

Sum({$<CategoryName=

{

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}

>}Sales)

Replace the Men’s Clothes with the string Blank like the table below

CategoryName	Sales
Totals	$41,494
Babywear	$1,563
Bath Clothes	$1,842
Children´s wear	$394
Ladies´Footwear	$3,151
Men´s Clothes	Blank
Sportwear	$16,153
Womens wear	$18,390

Instead of the value $0 like the table below

CategoryName	Sales
Totals	$34,288
Babywear	$1,563
Bath Clothes	$1,842
Children´s wear	$394
Ladies´Footwear	$3,151
Men´s Clothes	$0
Sportwear	$16,153
Womens wear	$18,390

Here is my spreadsheet data

CategoryName	Sales
Men´s Clothes	-$5,809.44
Womens wear	$394.13
Womens wear	$1,308.29
Womens wear	$1,842.34
Womens wear	$5,809.44
Womens wear	$9,035.75
Sportwear	$1,308.29
Sportwear	$9,035.75
Sportwear	$5,809.44
Bath Clothes	$1,842.34
Ladies´Footwear	$1,308.29
Ladies´Footwear	$1,842.34
Children´s wear	$394.13
Babywear	$55.94
Babywear	$1,308.29
Babywear	$198.98
Men´s Clothes	-$476.50
Men´s Clothes	-$927.71

Can you show me how to do that?

Re: Convert value to string

mikaelsc — Sat, 20 Oct 2018 10:39:58 GMT

Sum({$<CategoryName=

{

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}

>}Sales)

Sum({1<CategoryName=

{

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}

>}Sales)

Re: Convert value to string

mikaelsc — Sat, 20 Oct 2018 10:42:45 GMT

sorry, misread... this is to show the 0;

for the null instead of 0:

if(yourExpression = 0,'',yourExpression)

Re: Convert value to string

jhonesnow — Wed, 16 Nov 2022 08:26:27 GMT

Sum({$<CategoryName=

{

'Womens wear',

'Sportwear',

'Shower Garments',

'Ladies'Footwear',

'Youngsters' wear',

'Babywear'

}

>}Deals)

Sum({1<CategoryName=

{

'Womens wear',

'Sportwear',

'Shower Garments',

'Ladies'Footwear',

'Youngsters' wear',

'Babywear '

}

>}Deals)

Re: Convert value to string

greentay — Mon, 27 Feb 2023 10:13:09 GMT

To replace the value of "Men's Clothes" with "Blank", you can modify your set analysis expression as follows:

Sum({$<CategoryName=

{

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear',

'Men´s Clothes'-

}

}Sales)

Note that we added "Men´s Clothes'-" to exclude the "Men's Clothes" category from the set. This will replace the value of "Men's Clothes" with a blank value.

Your updated table should look like this:

CategoryName	Sales
Babywear	$1,563
Bath Clothes	$1,842
Children´s wear	$394
Ladies´Footwear	$3,151
Men´s Clothes
Sportwear	$16,153
Womens wear	$18,390

Hope this helps!