different expressions in table column

[#1]

Hi

my problem seems of low interest, maybe I use the wrong titles

Any way to create a table showing values like

KPI	Value
EBIT	= sum(EBIT_Detail)
EBIT %	= sum(EBIT_Detail) / sum(yield_Detail)

It's required that the % is in the same column (as I will have more rows with individual expressions)

I have an excel like grid in mind where I can set the cells content / formula

Juerg

[Anonymous · Accepted solution]

load a dummy table like

load* inline[

KPI

EBIT
EBIT%

]

and use a straight table with dimension as KPI and use expression if(  KPI=EBIT,sum(EBIT_detail),if(KPI= EBIT%,sum(EBIT_Detail) / sum(yield_Detail)))

[#3]

That is more or less what I tried but it does not work because - as I assume - the evaluation of the formula condition does not happen on the row level?

I think now about aligning text boxes into a gridlike layout - will cost me the selection feature however.

Correction:

Sorry - I was wrong.

What I tried was using a sequence number and =pick(sequence, <expr1>,<expr2>...)

and

multiple expressions with the conditions sequence=1, sequence=2

which did not work.

It does however work with the multiple if's.

Juerg