Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
lets supose we have a value V and a dimension D1,D2
It would be possible to make a indirect calculation like sum( D1=p(SUM(D2)=5) VALUE)
In this case we only want to sum those D1 VALUES where sum(D3)=5
Regards
Hi Victor,
surry, but - is this a question?
I don't think that
sum( D1=p(SUM(D2)=5) VALUE)
is valid syntax and will work as you want.
Maybe you can use an advanced search:
sum( {< D1= {"=sum(D2)=5"} >} VALUE)
Excuse me I forgot the question mark :
lets supose we have a value V and a dimension D1,D2
It would be possible to make a indirect calculation like sum( D1=p(SUM(D2)=5) VALUE) ?
In this case we only want to sum those D1 VALUES where sum(D3)=5
the question is i don't want the "sum" expression to be like sum(TOTAL D2) I WANT TO SUMMARIZE SUM(D2) FOR EACH D1 particularly so "sum expression" couldn't be inside "$()"
Regards
I knew that it existed that you called "advanced search" and was looking some tutorial about the syntax. could you please explain to me the rules of that kind of syntax. Thanks a lot. Is there a tutorial in any place?