Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Love Community,
I count reports together with the Count-Command.
This value changes when blocks are selected. Does anyone know a command to Keep this value constant?
regards
Use Set analysis
lFor example If you want month selection should not make any impact on your calculation then
Count({$<[MONTH]=>} [Product])
Say like:
=count({1<>}yourfield)
Put 1 inplace of $ n try..
Sachin
Or if u wan tht it should nt change based on particular attribute selection then try deepaks one
Sachin
That's right. It works, if I use this command with one field.
My example:
Count({1} [QV Report])
But I like working with set analysis like this:
Count(DISTINCT{1} {$<KPI = {'100_01', '100_02'}>}WERTMENGE)
Why doesn't work the additional function {1} with this set analysis? Do you have a solution?
try this
Count(DISTINCT {1<KPI = {'100_01', '100_02'}>}WERTMENGE)
Or
Count(DISTINCT {<KPI = {'100_01', '100_02'},[MONTH]=>}WERTMENGE)
also you can Detach your object as well
or set a new state
Also please donot create duplicate thread