Structure Formula: How to calculate with a specific value within Structure

Hans-Arno Wegner December 4, 2018

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

1 answer

0 votes
Hans-Arno Wegner December 4, 2018

(Was not able to delete this)

Suggest an answer

Log in or Sign up to answer