Forum Discussion
Solved
Divide one column by another
I have two tables, JobRuns & JobRunDocket I need to divide the number runs in one table by the number of associated dockets in another table. Each run can have multiple dockets. Number of loa...
Cheers for all the help people.
Unfortunately couldnt manage to get the answer I wanted with the calculations recommended.
Did however manage to connect to an SQL view that was written with the right data in it.
Didn't know that was possible but all working well now.
ED.
Cheers for all the help people.
Unfortunately couldnt manage to get the answer I wanted with the calculations recommended.
Did however manage to connect to an SQL view that was written with the right data in it.
Didn't know that was possible but all working well now.
ED.
newcolName =
DIVIDE(
SUM('table1'[col1]),
SUM('table1'[col2])
)