
1. Re: Conditional sum across a row of data (Emulate a hlookup in excel)
Jim Dehner Jun 21, 2018 8:22 AM (in response to Donald Olsen)Hi Donald
You are pulling data from Oracle and have several sheets  otherwise I would recommend pivoting the data  it is a better solution but that may mess other things you are doing
see the attached
I wasn't able to tell if each group had a common min date
but for each group the min date is (if you can pivot the data this can all be done in a single formula
after you do this 4 times the min of the min is
min is a binary function so nesting was required to get the min of the 4
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Newmodel OFS version_v10.2.twbx 626.8 KB


2. Re: Conditional sum across a row of data (Emulate a hlookup in excel)
Donald Olsen Jun 21, 2018 8:45 AM (in response to Jim Dehner)Thank you for the quick response. I will have to try and manually recreate what you did at the moment I have Tableau 10.1 and will need to have my company approve the upgrade.

3. Re: Conditional sum across a row of data (Emulate a hlookup in excel)
Donald Olsen Jun 25, 2018 11:56 AM (in response to Jim Dehner)Hi Jim,
How can I modify to account for where I have a zero in one of the data points. As you have done it it works in all cases as long as none of the sum's are not zero?
It's almost there where as you suggest I can do a pivot on the result but with this slight issue.

Newmodel ODN version_v10.2.twbx 641.8 KB
