Trying to divide a number by a number in another row.

Jonny Breen shared this question 3 years ago
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?

Comments (6)

photo
1

Sorry should of said, those red numbers are what I'm looking to achieve in YellowFin but cant.

photo
1

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

photo
1

Hi Jonny,

As general a thought, if you are looking for resources to help in learning Yellowfin I would recommend the following:

  1. Yellowfin University
  2. Yellowfin Wiki
  3. Yellowfin Community Knowledge Base

Regards,

Nathan

photo
1

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

photo
1

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

photo
1

Hi Jonny,

Going to set this case to closed for now but let me know if you run into any problems!

Regards,

Nathan