
Re: How I get the Numbers with x ?
Adam Wilson Jan 3, 2013 11:27 AM (in response to jörn kunz)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

Re: How I get the Numbers with x ?
Gysbert Wassenaar Jan 3, 2013 3:34 PM (in response to jörn kunz)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])

Re: How I get the Numbers with x ?
jörn kunz Jan 4, 2013 4:10 AM (in response to Gysbert Wassenaar )Thank you it works.
But can you me explain, why do you need the {<{}>} formulas?

Re: How I get the Numbers with x ?
khadeer basha Jan 4, 2013 4:18 AM (in response to jörn kunz)That function is written in set analysis, that is necessary for set analysis.


Re: How I get the Numbers with x ?
jörn kunz Jan 4, 2013 7:23 AM (in response to Gysbert Wassenaar )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.

Re: How I get the Numbers with x ?
Gysbert Wassenaar Jan 4, 2013 12:20 PM (in response to jörn kunz)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.

Re: How I get the Numbers with x ?
jörn kunz Jan 7, 2013 4:37 AM (in response to Gysbert Wassenaar )Thank you, it is the right answer.


