Anyone with some knowledge on how to build IIF statements through queries, your help is much appreciated.
Essentially what I'm trying to do is take this fee schedule among others...
0to $100,000,000*(0.3500%$ = $ 350,000
$100,000,000 to $200,000,000* (0.3000%) $ = $ 300,000
$200,000,000 to $500,000,000* (0.2500%) $ = $ 750,000
$500,000,000 to $1,000,000,000* (0.1750%) $ = $ 875,000
$1,000,000,000 to 0.1200% $ -
So what I have no idea how to code is having this be calculated, then add the values so let's say the invesment is $300,000,000.
It would need to calculate the $350,000 + $300,000 then subtract 300,000,000 - 200,000,000 and multiply the remaining $100,000,000 by the 200-500 fee of 0.25%.
I hope I'm not over everyone's head here, its fairly straight forward but difficult to code into a query. All I need is an example of coding this or a db with similar calculations if anyone has, I'm a legit novice.
Thanks