Skip to Content
Former Member
Dec 29, 2012 at 04:50 PM

How to set formula in query for blank value


Hi Friends,

Need your help / guidance..

I have 1 sales query, in which there are 4 columns

Indent Qty

Indent Value ( B )

Sales Qty

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.

Please help.