Hi!
I would like to use the calculated average value of a specific structure folder row for another formula.
Simlified example:
- FolderA | valueA | valueB | valueC1
- Subitem | valueA | valueB | valueC2
- Subitem | valueA | valueB | valueC3
- FolderB | valueA | valueB | valueC4
Now I want to create a formula which multiplies for each row valueB * valueC2
How to reference to a specific value (valueC2) in structure? Is this possible?
I tried for instance to use WITH <Reference to the specific value> : <value>
But I do not find a way to reference. Perhaps something like
Folder(summary"FolderA", valueC1) ?
But this doesn't work so far.
Thanks in advance for any help!
Ciao
Hans-Arno
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.