Hello guys i have facing a problem in script level.
i want to pick value in row using condition. please see my attach file.
i have two filed which name one is opening quantity and one is closing quantity
i will create a calculated filed which name is NewOpqty.
please see my image file and also see my script if you have any idea then please share with me.
i need this condition if(opening quantity<>0 ,opening quantity,peek(opening quantity)) and also need this condition
if closing quantity<>0 then peek(closing quantity) or opening quantity.
But some how my condition will not working.
Thanks in advance
Not sure, I understand your concern. Can you please share sample?
Which table we need to look?
I used this condition ....
if( New_MasterCode <> Peek(New_MasterCode) , If( MasterCode <> Peek(MasterCode), IF( Opening_Qty <> 0 ,Opening_Qty , Peek(NewOpQty) ) ), If(Opening_Qty = 0 ,Peek(Closing_Qty) , Opening_Qty) ) as NewOpQty,
but its not working
That means, You are going to call 2 if..else statement using single IF statement? Isn't it?
Brother i want a new column which is depends on opening qty and closing qty.
i have opening for each new master code which have only one date.
i just need if opening quantity is 0 then its peek opening quantity depend on closing quantity if closing quantity has value then opening is show me the closing value.