Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
This is with regard to set analysis :
count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country)
The double quotes doesn't work inside the element set , with single quote output is not correct
Hi Arvind,
Single quotes wouldn't work for search strings. Instead try with back quote sign (grave accent) `, like:
count({$<Country = {"=sum({$<Week = {`>$(vTest)`}>}Sales) > 1000"}>}distinct Country)
What about this?
count({$<Country = {"=sum({$<Week = {'>$(vTest)'}>}Sales) > 1000"}>}distinct Country)
Hello ,
thanks for the reply but this option is already tried , it returns zero instead of correct output
Hi Arvind,
Single quotes wouldn't work for search strings. Instead try with back quote sign (grave accent) `, like:
count({$<Country = {"=sum({$<Week = {`>$(vTest)`}>}Sales) > 1000"}>}distinct Country)
Thanks a lot Tresesco , it works