query to calculate different %

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probadly simple, but I can't get anything to work.
I have a net profit for charity, which I need to calculate
at 20% up to $75000, then anything over $75000 I need to
calculate at 50%
Say net profit is $100,000
20% of $75000 would be $15,000 the remainding $25,000 would be
calculated at 50%
50% of $25,000 would be $12,500
The result should be $27,500
I have tried everything I can think of , but nothing works
Thanks for any help
Roger
 
This is probadly simple, but I can't get anything to work.
I have a net profit for charity, which I need to calculate
at 20% up to $75000, then anything over $75000 I need to
calculate at 50%
Say net profit is $100,000
20% of $75000 would be $15,000 the remainding $25,000 would be
calculated at 50%
50% of $25,000 would be $12,500
The result should be $27,500
I have tried everything I can think of , but nothing works
Thanks for any help
Roger
Click to expand...

IIF([Profit] <= 75000, 0.2*[Profit], 15000 + 0.5*([Profit] - 75000))


John W. Vinson[MVP]
(no longer chatting for now)
 
Thanks John
That works great, but when I pull it into a report. It only picks up the 1
entry as more than 75000. I have entries all through the month that are for
$300 or 400 and when the grand total gets over 75000 is when the 50% kicks
in. Is there any way to do this for a report. I tried using the same
formula, with the sum before each of the Profit, but it didn't work.
Thanks for any help
Click to expand...

Ummm... you didn't SAY that. <g>

You'll need to use DSum() to sum the values month-to-date. This could
be pretty complicated; I can't think of a simple expression to do it!
Maybe you should repost (with this explanation), maybe someone who
knows more about reports can make a suggestion. Sorry!

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top