Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TOTAL IN QUERY

Hi,

I want to display total in query for each row like unit price + landed cost.Here unit price is always there but landed cost is applicable some times .So in some records it is blank.so in those case the total also appears as blank.

Pls let me know how to handle this.

Rgds,

Rajeev

replied

hi,

murtaz is right.

u have to used isnull function.

eg.

select sum(isnull(b.quantity,0 )) from ibt1 b

regards,

Avijit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question