How I get the Numbers with x ?

[#1]

Hello,

my next problem, I have two columns external and amount days. I need only the days with x in the same row.

External	Amount of days
x	2
	5
x	4
x	3
	9

After that I need to calculate the Average days of the external.

Could you help me, to give me the spirit to the solution.

Thanks.

[adamwilson]

Hi,

To calculate the average days of External, create a chart, use External as your dimensions and Avg([Amount of days]) as you expresion.

This will result in one row for each distinct value in External with the average of Amount of days.

Adam

[Gysbert_Wassenaar · Accepted solution]

If you need the average of the days where External has the value 'x' try this expression in a text box:

=avg({<External={'x'}>} [Amount of Days])

[#4]

Thank you it works.

But can you me explain, why do you need the {<{}>} formulas?

[khadeer]

That function is written in set analysis, that is necessary for set analysis.

[#6]

How can I get the formular in a YTD Formular:

This here is my try, but it doesn't work:

avg({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=>}avg({<[FAK Kennzeichen]={'X'}>} [Anz Tage])

Could you help me.

Thanks.

[Gysbert_Wassenaar]

Try: avg({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=,[FAK Kennzeichen]={'X'}>} [Anz Tage])

This all assumes you have fields called Year, Month and Date and a variable called vMaxDate that contains a valid date value.

[#8]

Thank you, it is the right answer.