Suppress Null value in Text box

[abhaysingh]

hi,

how to remove null value in text box??

i need to show max(temp) for Sensor ID, right now there are few null values in it so it is showing max of temp of null value.. which is wrong..

i did not want to show null value how i can handle it in text box?

pls suggest?

[sunny_talwar]

May be this:

Max({<[Sensor ID] = {"=Len(Trim([Sensor ID])) > 0"}>}temp)

[swuehl]

Maybe like

max({<SensorID = {"*"}>}temp)

[Gysbert_Wassenaar]

Try this: max({<[Sensor ID]={'*'}>}temp)

[Chanty4u]

can u shre sample?

[engishfaque]

Deara Abhay,

Here it's,

Max({<[Sensor ID] -= {'Null()'}>} temp)

Kind regards,

Ishfaque Ahmed