Hi Guys,
Just found this forum so hoping you can help!
I have a pivot table with the following nested IF statement in the calculated field section but it only appears to be picking up the >20% part and the *8% bit at the end...any ideas why?
Thanks
<tbody>
Bonus
=IF('% Margin'<0,0,IF('%...