Forum Discussion
Margin Divisible by 5?
Hi, I am looking to find a calculation that will tell me whether an item was sold at a margin divisible by five or not. i.e. ..., 35%, 40%, 45%, 50%, ... etc. I figured it would be simple using ...
Sale Prices of $0.00 were creating -infinity values which was screwing it up. I stacked another IF statement on top of the other, saying IF([Sale]=0, IF(MOD([Margin], .05) = 0, "True", "False"), "False")
MattAllington
Community Champion
Community ChampionIs margin a measure or a calc column? Is DivisibleBy5 a measure or a calc column?
- MattAllington
Well it looks right. Can you post a sample of the values in the margin column?
- MattAllington
here is my formula and it works fine. So I have to think something strange is happening to your data column. Do you have any rougue values somewhere in the column? Try writing a calc column =Max(table[total cost margin]) and see what you get