Purplethunder
New Member
- Joined
- Feb 8, 2019
- Messages
- 2
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
[TABLE="width: 1372"]
<tbody>[TR]
[TD="width: 59"]Bonus[/TD]
[TD="width: 1313"]=IF('% Margin'<0,0,IF('% Margin'>20%,'Margin Amount'*25%,IF('% Margin'>19%<20%,'Margin Amount'*20%,IF('% Margin'>18%<19%,'Margin Amount'*15%,IF('% Margin'>17%<18%,'Margin Amount'*10%,'Margin Amount'*8%)))))
[/TD]
[/TR]
</tbody>[/TABLE]



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
[TABLE="width: 1372"]
<tbody>[TR]
[TD="width: 59"]Bonus[/TD]
[TD="width: 1313"]=IF('% Margin'<0,0,IF('% Margin'>20%,'Margin Amount'*25%,IF('% Margin'>19%<20%,'Margin Amount'*20%,IF('% Margin'>18%<19%,'Margin Amount'*15%,IF('% Margin'>17%<18%,'Margin Amount'*10%,'Margin Amount'*8%)))))

[/TR]
</tbody>[/TABLE]


