Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone:)
i have a question to a set analysis in combination with a variable
my expression
sum({< ID ={"$(ID)"}>} XXX / sum(aggr(max({< ID = {"$(ID)"}>}XXX), YYY,ZZZ))
I ignore also some fields with a statement in the set analysis with XXX=, but it's still not work ....
can anyone help me:)
THANK YOU:)
Please try:
sum({<XXX=, ID ={"$(ID)"}>} XXX )/ sum({<XXX=>}aggr(max({< ID = {"$(ID)"}>}XXX), YYY,ZZZ)
Not sure if this is the problem, but you are missing a parenthesis:
=Sum({<0ID = {"$(ID)"}>} XXX) / Sum(Aggr(Max({< ID = {"$(ID)"}>}XXX), YYY,ZZZ))
HI plz try this one
=sum({<XXX=ID ={"$(ID)"}>} XXX / sum({<XXX=>}aggr(max({< ID = {"$(ID)"}>}XXX), YYY ,ZZZ))
it's still not working
it's perfect working if i do this set analysis without aggr. but then i lost my data quality..:(
= SUM({1< Quarter = {"$(vQuarter)"}>} XXX / SUM(AGGR(MAX({1< Quarter ={"$(vQuarter)"}YYY), ZZZ,WWW))
The problem is the AGGR....anyone an idea?
THANK TO YOU ALL:)
Can you explain what you are trying to do?
it's little bit difficult but it's a KPI... and i need this calculation for this KPI.
The Problem is the AGGR... i do this set analysis without AGGR it's perfect work but i need this for the KPI..:(
why i have so problems with the AGGR???