2 Replies Latest reply on Jan 31, 2019 12:23 PM by Erin Agobert

# What ratio of rows are unprofitable?

Hi.  I'm working on a question where I have to determine which ratio or rows are unprofitable in the "Fasteners" sub-category.  My problem is I think I have the solution, but I've been given a choice of A: 0, B: 1, C: .055, D: .55 and my solution doesn't correspond to any of these options.  Could someone assist me in determining where I've gone wrong?

• ###### 1. Re: What ratio of rows are unprofitable?

Check out the duplicated Logic Calcs Challenge (2) tab in the attached .twbx.  I believe you may have overcomplicated things a bit here -- a simple calc of

IF Profit < 0 then "Unprofitable" else "Profitable" END

should suffice, used as color on a Number of Records bar, then using % of total to grab the results you're after.  If you want it in a text view, its just a matter of moving things around at this point.

Cheers and happy analyzing!

3 of 3 people found this helpful
• ###### 2. Re: What ratio of rows are unprofitable?

Matt thank you.  The correct answer was C.  I'm not sure where I went wrong and you definitely made the answer look easy.