Forum Discussion
elliotdixon
Responsive Resident
Responsive ResidentDivide 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.
leonardmurphy
Skilled Sharer
Skilled SharerExcellent point. I always forget that until I get a divide by zero error.
elliotdixonResponsive Resident
Responsive ResidentCheers 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])
)