Logic Help..

[abhaysingh]

Hi All,

i have one table in which Temperature,minimum and maximum temperature is available against assets,,

i want in text object that when Asset Temperature is in range it will give count of Day.

i.e. Number of Days assets works properly.

if a Asset Temperature is in Range of Min and Max Temperature than it is gud and i want to calculate no of Days for Assets is gud..

Pls suggest

[maxgro]

sum( {$<AssetTemperature = {“>MInTemp<MaxTemp”}>} distinct Days )

[abhaysingh]

thanks but not working

[maxgro]

could you post a small .qvw with your data?

[Anonymous]

may be Temprature format is the issue?

How you are storing Temprature and Min/Max values? may be like 23 C??

Try to convert it into Num()

[abhaysingh]

no these are values 20,21, etc

[Mark_Little]

Hi,

have you thought about adding a flag in the data?

Something Like

If(Temp>= Min and Temp<=Max, 1,0) as InRange,

Then you can then just Sum(InRange)?

Mark