Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I just got some help, but i need some more
I have the following expression:
=time(Frac(now(1)))>Open AND time(Frac(now(1)))<Close AND PRU = 'A' AND AREA = 'B'
I have two list boxes also whitch show PRU and AREA.
I want to have several gauge chart showing the different PRU and AREAS and if they are open or not.
So i wanna have one for PRU A and AREA A, Then one for PRU A and AREA B etc.
I dont want to make any selection within this application. I want the user just to see if the store i open right now or not.
This does not work atm. If i choose PRU A and AREA B in the listbox i get the right answer (-1 for open and 0 for closed).
How can i get this to work?
Thanks!
Found it, it was just an ( to much. I think you solution works. Will try a bit more!!!!