Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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).
Try like:
sum({<categoryname={'men''swear'>}unitprice)
Hi @nagarjuna9629 ,
I think there are a brace and quotation marks missing: =sum({<categoryname={"men'swear"}>}unitprice)
its not working
it's working sir
@nagarjuna9629 , please ensure that you use two single quotes in the middle and not a double quote - then it would work.
Thanks. Please tag my answer as correct, so others can benefit from this thread as well.
@tresesco I think it is not men AND swear but men's wear like men's clothes
i was tried that one also...but result shows 0
@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).
you're right, it works. But I don't know why 🙈
I always use double quotes...