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%.
max(38.5%,(min(60.5%,(54%-[Losses]/[Premium])+38.5%))
How do I make this work in Tableau?
Thanks,
Miles
Essentially, it's the same, but you're missing a last parentheses and you've included the percent sign. You need this:
max(38.5,(min(60.5,(54-[Losses]/[Premium])+38.5)))
Or thinking about it this:
max(38.5*100,(min(60.5*100,(54*100-[Losses]/[Premium])+38.5*100)))