Need your help / guidance..
I have 1 sales query, in which there are 4 columns
Indent Value ( B )
Sales Value ( C )
Sales Price = this is formula based
now the formula is, if sales qty and sales value is blank then it should pickup the value of indent qty and indent value.
I have set the formula, but the problem is bw cannot recognized blank value.
Can you pl let me know how should i resolve this?
I was thinking of writing na end routine, bcz sales qty and sales value is based on value types, so if those value types are there then i shall update 0 in end routine.