how to calculate rejection index.

[Syndicate_Admin]

Good afternoon

I'm wanting to put together a column in my table to be able to separate the values that are return so then I can calculate the percentages of rejection of my logistics, in one of the columns I have that is called TYPE I have the values DEV (of return) and VEN (of sale) and another of AMOUNT that indicates the billing of that voucher. what I would need is that if the TYPE is DEV I return the value and if it is VEN I return value 0. I don't know if I explain myself correctly?

voucher	guy	Matter
Invoice 1234	DEV	$155
invoice 3934	Come here	$189
invoice 948	DEV	$1862

[fhill · Accepted solution]

1. Right Click your Table, and select 'New Column'

2. Now you can use traditional IF THEN logic looking at each row (vs. Measures where this is harder)

Column = IF ( 'Table (3)'[Type] = "DEV", 'Table (3)'[Amount], IF ('Table (3)'[Type] = "VEN",0))

Hope this helps...

Forrest