I'm trying to embed a min formula inside a max formula. This is a calculation that I often use in excel - the ratio that I'm trying to calculate slides between 38.5% and 60.5%, when the ratio of [Losses]/[Premium] moves between 54% and 32%.
How do I make this work in Tableau?
Essentially, it's the same, but you're missing a last parentheses and you've included the percent sign. You need this:
Or thinking about it this: