Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in a table I will find min/max value of GJ_Woche. In textboxes are the min/max values, but how can I get GJ_Woche of min/max and what’s wrong on textbox Rows. There is not the correct NoOfRows?
Regards
Stefan
Use script as below
TEST:
LOAD *, RowNo() as NO Inline [
GJ_Woche, Erloes
2010/01, 1.348
2010/02, 2.854
2010/03, 2.933
2010/04, 2.299
2010/05, 2.775
2010/06, 2.933
2010/07, 4.598
2010/08, 2.141
];
For No of rows in Text Box
= 'Rows ' & Max(NO)
Or, you can try :
= 'Rows ' & Aggr(NoOfRows(),GJ_Woche)
try this in object
='Total Rows' & aggr(noofrows(),GJ_Woche)
Hi Stefan
you can use 'count' function insted of 'NoOfRows'
= 'Rows ' & Count (GJ_Woche)
Regards
Harsha