Mathematical question

[ift_isabelle]

How can i put this formule in Qlik Sense?

dX = (X - 155000) * 10 ^ -5

dY = (Y - 463000) * 10 ^ -5

I tried:

(X - 155000) * 10 ^ -5 As dX,

(Y - 463000) * 10 ^ -5 as dY

But Qlik Sense doesn't recognize the  " ^ " symbol.

Thank you in advance,

Kind Regards,

Isabelle

[sunny_talwar · Accepted solution]

May be this:

Pow((X - 155000) * 10, -5) as dX,

Pow((Y - 463000) * 10, -5) as dY

UPDATE: Just realized from Gysbert's post that the whole thing is not raise to -5. May be this:

(X - 155000) * (Pow(10, -5)) as dX,

(Y - 463000) * (Pow(10, -5)) as dY

[Gysbert_Wassenaar]

(X - 155000) /100000