longlam
September 21st, 2006, 07:14 PM
Hello Everyone,
I'm having a problem creating a formula that will give me the return rates for all my items. All the transaction I'm looking for is based on the same table. I have filtered it so that I only get invoices and credit memos. I have pushed this data into a crosstab report so and used transaction type as the column so that it splits up the invoices and the credit memos. Now I want to create a formula based on the two columns so that I can get the return rate (credit memos/invoices *100). I have yet been able to figure out how to do this. Also, where would I place the forumla on the cross tab? Or can I even do that? Lastly, if I grouped by item but would like more information about the item such as it's size and color which is stored in different fields, how can I append it to the cross tab table so it appears on the same row as the item?
Thanks for the advise in advance!
I'm having a problem creating a formula that will give me the return rates for all my items. All the transaction I'm looking for is based on the same table. I have filtered it so that I only get invoices and credit memos. I have pushed this data into a crosstab report so and used transaction type as the column so that it splits up the invoices and the credit memos. Now I want to create a formula based on the two columns so that I can get the return rate (credit memos/invoices *100). I have yet been able to figure out how to do this. Also, where would I place the forumla on the cross tab? Or can I even do that? Lastly, if I grouped by item but would like more information about the item such as it's size and color which is stored in different fields, how can I append it to the cross tab table so it appears on the same row as the item?
Thanks for the advise in advance!