Hi, Is there a way to multiply two columns i...

(AndreiT Vlad) #1

Hi,

Is there a way to multiply two columns inside a Select? Something like SELECT(tableName[Col1]*[Col2], CONDITION) ?

That will be really helpfull

Thanks!

(Steven Coile) #2

Nope. :frowning:

(Reza Raoofi) #3

And since it is not possible, you could create a Virtual Column with this App Formula and then use that in your SELECT(…) expression:

=[Col1]*[Col2]