picking last row

[kauser]

hello, 

how can i pick the last row with value - 

Input Data- 

F1
5,656.00
11,312.00
22,624.00
45,248.00
-
-
-
-
-
90,496.00
180,992.00
361,984.00
723,968.00
1,447,936.00
2,895,872.00
5,791,744.00
11,583,488.00
23,166,976.00
46,333,952.00
92,667,904.00
NULL
NULL
NULL
NULL

i want to pick last row only with value- 

92,667,904.00

[MelGibson]

Add a filter tool      !isnull([F1]) and [F1]!='-'

then add a sample tool last N Row where N = 1

[kauser]

Hello @MelGibson  somehow its not working 

[binu_acs]

@kauser in the filter tool add the below condition if @MelGibson @is not working

[F1] !='NULL' 

then add the sample tool and select the last 1 record 

[kauser]

Hello @binu_acs  when i am using this formula - 

[F1] !='NULL'

and

[F1] !="-" 

i got this results- 

5,656.00
11,312.00
22,624.00
45,248.00
90,496.00
180,992.00
361,984.00
723,968.00
1,447,936.00
2,895,872.00
5,791,744.00
11,583,488.00
23,166,976.00
46,333,952.00
92,667,904.00

some how its not picking last value

[MelGibson]

You will need to add the sample tool at the end that is Last N rows with N = 1

[nagakavyasri · Accepted solution]

@kauser 

[flying008]

Hi, @kauser 

FYI. The expression of Filter tool also can be 

REGEX_CountMatches([F1], '\d')