Trying to divide a number by a number in another row.
Answered
Hi, first question :) Managed success so far by hitting enough buttons but am struggling with this. I am trying to divide a persons hours by the contracted hours. Their hours is broken down to several codes as shown in screenshot, but because their contracted hours is an entirely different piece of data it sits in another row which wont allow me to divide by it?
Files:
YFIssue1.png
Sorry should of said, those red numbers are what I'm looking to achieve in YellowFin but cant.
Sorry should of said, those red numbers are what I'm looking to achieve in YellowFin but cant.
Hi Jonny,
Thanks for getting in touch! To divide two columns, you will need to either use a calculated field or an advanced function. Typically the calculated field is the best route to take here:
http://wiki.yellowfin.com.au/display/USER73Plus/Calculated+Fields
Is this something you have tried?
Regards,
Nathan
Hi Jonny,
Thanks for getting in touch! To divide two columns, you will need to either use a calculated field or an advanced function. Typically the calculated field is the best route to take here:
http://wiki.yellowfin.com.au/display/USER73Plus/Calculated+Fields
Is this something you have tried?
Regards,
Nathan
Hi Jonny,
As general a thought, if you are looking for resources to help in learning Yellowfin I would recommend the following:
Regards,
Nathan
Hi Jonny,
As general a thought, if you are looking for resources to help in learning Yellowfin I would recommend the following:
Regards,
Nathan
Hi Nathan
Thanks for the reply! Those resources have been great in developing everything to date. I've tried Calculated fields but the division wont work because the value is on another Row since it doesnt align with the time codes. And because I want the calculation for every line with time I get a zero value. Alternatively I was looking into Advanced function to push a contacts contracted hours to every row but no luck there either.
Thanks! Jonny
Hi Nathan
Thanks for the reply! Those resources have been great in developing everything to date. I've tried Calculated fields but the division wont work because the value is on another Row since it doesnt align with the time codes. And because I want the calculation for every line with time I get a zero value. Alternatively I was looking into Advanced function to push a contacts contracted hours to every row but no luck there either.
Thanks! Jonny
Hi Jonny,
Do you have a few minutes to screen-share? If so, we can use this link:
https://meetings.ringcentral.com/j/1484996205
Regards,
Nathan
Hi Jonny,
Do you have a few minutes to screen-share? If so, we can use this link:
https://meetings.ringcentral.com/j/1484996205
Regards,
Nathan
Hi Jonny,
Going to set this case to closed for now but let me know if you run into any problems!
Regards,
Nathan
Hi Jonny,
Going to set this case to closed for now but let me know if you run into any problems!
Regards,
Nathan
Replies have been locked on this page!