Hi all,
Given a number (a tax) I need a logic to multiply an amount with the tax to the power of a variable number of years. That it, given T, I need
Amount*T ^ #_years
Can we do that with SQL Logic?
I have seen the MDX formula power(a,b), but I'd like to avoid MDX statements. If there is no other way to calculate the power, can we calculate a temporary account with MDX (like #result) and then use it in a WHEN/IS statement?
Regards,
Rafa