Find min and max value

[Anonymous]

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

[MK_QSL]

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)

[tresB]

Or, you can try :

= 'Rows ' & Aggr(NoOfRows(),GJ_Woche)

[er_mohit]

try this in object

='Total Rows' & aggr(noofrows(),GJ_Woche)

[Anonymous]

Hi Stefan

you can use 'count' function insted of 'NoOfRows'

= 'Rows ' & Count (GJ_Woche)

Regards

Harsha