Good morning Henry
Not sure I fully understand your goal -
But I think the LOD calculation is not needed - just a simple calculation Gross Profit/Gross Loss will suffice
Attached is a T10.1 workbook based on superstore data
Let me know if this helped
LOD calc.twbx 1.2 MB
To answer your specific questions:
1) Any suggestions to how to accomplish this in Tableau? This Profit Factor should also be affected by filters.
AW - Put the filters to context if using FIXED
2) Is there a more elegant approach to my data so I don't need to have a separate gross profit and gross loss column?
AW - Profit and Loss will have to be extracted separately, not necessarily as columns but in calculated fields
Agree with Jim, there might not be need for LOD calcs here, it all depends how you intend to use it. Without the LODs you don't need filters in context, which should give a performance gain.
Thanks a lot Jim and to all.
Fixed was helpful for me too to get another measure but you're right I made it slightly over complicated.
This met my needs
Glad to be of help
Thanks for the shout out