Hello Friends,
Could someone please tell me how I can assign 0 to a number feiled in a report when it has null value.
I have something like this:
Sales Return NetSales
500 100 400
300
400 500 -100
the formula i have in NetSales is: sales-return(obviously), but when return is null the NetSales also comes out to be null.
Could someone please tell me how I can assign 0 to a number feiled in a report when it has null value.
I have something like this:
Sales Return NetSales
500 100 400
300
400 500 -100
the formula i have in NetSales is: sales-return(obviously), but when return is null the NetSales also comes out to be null.