Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All,
I have one temperature field which have value against every sensor.
i am calculating min(Temp) and Max(Temp) so i am getting one value against without any selection.
Now i want when i am not selecting sensor it should not give me any Value.
i mean Min(Temp) and Max(Temp) should be blank.
how i can do this.
thanks
May be this:
If(GetSelectedCount(Sensor) > 0, Min(Temp))
If(GetSelectedCount(Sensor) > 0, Max(Temp))
Hello Abhay,
further to Sunny T's response you should use the if statement like this:
If(GetSelectedCount(Sensor) > 0,1,0)
This should be used within the calculation condition of the properties of the chart object. This basically will then only return the calculations once the condition in the if statement is met.
If this response is helpful, please mark this as helpful and a correct answer.
try,
If(GetSelectedCount(Sensor) =0,0, YourExpression)