set analysis

[nagarjuna9629]

In set analysis,

category names& unit price:

sportswear-500

men's clothes-880

women's clothes-900

the value of   

 =sum({<categoryname={men'swear>}unitprice)

shows zero

wher i did mistake?plz find my mistake

[tresB]

Try like:

sum({<categoryname={'men''swear'>}unitprice)

[ManuelRühl]

Hi @nagarjuna9629 ,

I think there are a brace and quotation marks missing:    =sum({<categoryname={"men'swear"}>}unitprice)

[nagarjuna9629]

its not working

[nagarjuna9629]

it's working sir

[tresB]

@nagarjuna9629 , please ensure that you use two single quotes in the middle and not a double quote - then it would work.

[ManuelRühl]

Thanks. Please tag my answer as correct, so others can benefit from this thread as well.

@tresB I think it is not men AND swear but men's wear like men's clothes

[nagarjuna9629]

i was tried that one also...but result shows 0

[tresB · Accepted solution]

@nagarjuna9629 , @ManuelRühl , it works with me.  And I am sure, it should work with you as well, if you are not mixing up the single and double quote that I mentioned above (i.e. - the two single quotes and not double quote).

[ManuelRühl]

you're right, it works. But I don't know why 🙈

I always use double quotes...