I am trying to create a variable which will give me the Starting On Hand Balance which is called <Opr All Qty>. I am also pulling up the Date posted. I am trying to get the Starting On Hand Balance based on the starting Date Posted.
When I tried:
=<OPR ALL QTY> where min(<Date Posted>)
I get a syntax error. I am assuming I need to add a select statement to my where clause? Or is there another way?
Thanks!
When I tried:
=<OPR ALL QTY> where min(<Date Posted>)
I get a syntax error. I am assuming I need to add a select statement to my where clause? Or is there another way?
Thanks!