Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have already dealt with cursor on integer field, but now i have to deal with cursor on intervall.
My chart contains a duration (mm:ss) and i when i create a cursor it don't works.
Nothing appears in my chart except if i select in my cursor Min_value=0 and Max_value=0. In this case, all values are displayed in the chart.
In the exemple below, i'd like display only districts with duration between 4 and 7 min.
Regards
Try this:
=If($(V_avg_duration) > vMin and $(V_avg_duration) < vMax, $(V_avg_duration))
Where vMin and vMax are two new variables
vMin: =MakeTime(0, V_min_value)
vMax: =MakeTime(0, V_max_value)
Would you be able to share the sample with us to play around with?
Here a sample. Sorry for the delay!
Try this:
=If($(V_avg_duration) > vMin and $(V_avg_duration) < vMax, $(V_avg_duration))
Where vMin and vMax are two new variables
vMin: =MakeTime(0, V_min_value)
vMax: =MakeTime(0, V_max_value)
It works. Thanks to you