Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello..
i have a case that i have to count how much every dimension has the max value more then 0
dimension is "cd_name"
expression is max(value) to know how much is the maximum value
and to calculate max value more then 0 for every "cd_name" i use expression below :
if(count(max(value))>0,count(max(value))
)
but it shows no data
i try to change the expression to count(max(value))
and it shows no data neither
what's wrong with me?
and how to calculate it?
thx..
i really appreciate ur help
Hello Richardo,
I don't know if this is what you want, but I'd try
Count({< value = {'$(=Max(value))'} >} cd_name)
Hope that helps