Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago

hi

hi   I have a sales table where i have value sold and return. When  sold invoice number is normal a number but when return then there is CR at beginning and CR or return invoice number is not sam...
Need Help
abc_777's avatar
abc_777
Solution Specialist
3 years ago

I think I need to first remove the invoice starting with CR

 

then I have to check and compare if CR Net Amount if = Invoice net Amount then i have to remove that invoice also then sum (net amount) and divide count of invoive number

 

please help me to create this measure 

 

thanks

  • abc_777's avatar
    abc_777
    Solution Specialist
    3 years ago

    hi,

     

    Its my mistakes i couldn't give a good example file to understand. here ihave attached excel file. 

     

    where i can remove full and pertial returns, and match with customer_ID and invoice_DT with invoice number and CR number to remove then find the avg. 

     rows could be anywhere within 3 millions of data

     

    sorry for the inconvient.

     

    thanks