Skip to Content
0
Former Member
Mar 18, 2009 at 01:12 PM

Power of a number in BPC

35 Views

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