Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can I reference in a formula the Column created through Valuelist, when this Column consists of Field names?
My try is not working.
Thank you!
From what I understand, you should be able to do this
But it does not work in the example - it gives me zero.
First column is Dimension.
Column 1 (with Measure heading) contains the name of the field [Revenue]
Column 2 contains the formula: SUM( Column(1) ), but it returns null
I tried various things, like SUM ( '['&Column(1)&']' ) and on - still nothing.
Any suggestion?
Thank you.
Would you be able to share a sample?
Please, see attached.
What i am trying to do is to create a column with fieldnames list through Valuelist and use it as part of the formula in another column.
Thank you.