Forum Discussion
Solved
Measure calculation
Hello, I have a column with the name of a company the number of transaction and the percentage : I would like to calculate the sum of the transaction for a company + the same number * t...
measure =
var total = sum(transactions)
var abandoned = sumx(transactions * abandoned%)
return
total + abandoned
.....something like that? (you'll still have to add the filter conditions etc)
The thing is that the total of transactions per company is good but I don't know what code to write to tell that I want to multiply it by the column abandonment that correspond to the right company
measure =
var total = sum(transactions)
var abandoned = sumx(transactions * abandoned%)
return
total + abandoned
.....something like that? (you'll still have to add the filter conditions etc)