Convert value to string

[Anonymous]

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?

[mikaelsc]

Sum({$<CategoryName=

{

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}

>}Sales)

+

0*

Sum({1<CategoryName=

{

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}

>}Sales)

[mikaelsc · Accepted solution]

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

for the null instead of 0:

if(yourExpression = 0,'',yourExpression)

[jhonesnow]

Sum({$<CategoryName=

{

'Womens wear',

'Sportwear',

'Shower Garments',

'Ladies'Footwear',

'Youngsters' wear',

'Babywear'

}

>}Deals)

+

0*

Sum({1<CategoryName=

{

'Womens wear',

'Sportwear',

'Shower Garments',

'Ladies'Footwear',

'Youngsters' wear',

'Babywear '

}

>}Deals) 

[greentay]

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!