sales order status
My requirement is to show sales order by its status against billed amount.
if the net value and billed amount of the sales order is same then it's full order...
|Header 1||Header 2||Header 3||Header 4|
|Sales order||Net value||Billed amount||Status|
How do I achieve this status? At the moment, i export data to exel and doing Vlookup against COPA datasource billed amount data to achieve these statuses but I want to find out the status of sales orders in bex query.
I am using following data sources
Shall I be using difference datasource to achive this in bex query itself rather then doing vlookup?