Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having a little bit of trouble with the syntax of Set Analysis. When I write something like this:
sum( {$<NumberTest={"<=$(=sum(TotWeightedCasesCompare))"}>} PeerAmount)
It will evaluate as expected. When I try something like this:
sum( {$<NumberTest={"<=$(=sum(TotWeightedCasesCompare))/$(=sum(TotCasesCompare))"}>} PeerAmount)
The expression will no longer evaluate properly. Is performing division in this instance not allowed, or do I just have the syntax wrong?
Try this ways
=sum( {$<NumberTest={"<=$(=sum(TotWeightedCasesCompare))"}>} PeerAmount)
/
sum(TotCasesCompare)
Regards,
Anand
May be this
Sum({$<NumberTest = {"<=$(=Sum(TotWeightedCasesCompare)/Sum(TotCasesCompare))"}>} PeerAmount)
sum( {$<NumberTest={'<=$(=sum(TotWeightedCasesCompare)/sum(TotCasesCompare))'}>} PeerAmount)
sum({<NumberTest={"<=$(=sum(TotWeightedCasesCompare/TotCasesCompare))"}>}PeerAmount)
probably this will work. but still i m unable to understand what is exactly ur requirement is.
thanks