Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I was wondering if someone oculd help me write a function which may otherwise use the function between
I want to show the number of people with a waiting time between 60 and 120
I.e. If([Waiting_Time] between 60 and 120, 1,0) scenario
Can anyone help me?
Kind Regards
Helen
Unfortunately QV has no between function. You'll have to use if(Waiting_Time>=60 and Waiting_Time<=120,1,0)
Unfortunately QV has no between function. You'll have to use if(Waiting_Time>=60 and Waiting_Time<=120,1,0)
Hi,
You can write this script like
Before
If([Waiting_Time] between 60 and 120, 1,0)
similar to
If([Waiting_Time] >=60 and [Waiting_Time] <=120, 1,0)
HTH
Regards,
Anand
Hello
Thank you! It works. I should of realised what I should write it like that.
Thanks alot
Helen
Hello,
Thank you for this. It works
Thanks
Helen