Way to divide the values of two custom columns? | Adobe Higher Education
Skip to main content
Level 2
October 16, 2020
Resuelto

Way to divide the values of two custom columns?

  • October 16, 2020
  • 1 respuesta
  • 820 visualizaciones

I have two calculated custom columns driven by WEEKDAYDIFF expressions and I'd like to divide one by the other:

  • one column tells me the number of business days left until the Planned Completion Date
  • one column tells me the number of days difference between the Planned Completion Date and the Estimated Completion Date

For each task, I want another column to divide the value in the second column by the value in the first.

Is that possible? Please help!

Este tema ha sido cerrado para respuestas.
Mejor respuesta de ManuelBa

You probably have to merge the two calculations in one big set of formula. Direct access to another column doesn't work as far as I know...

1 respuesta

ManuelBaRespuesta
Level 4
October 16, 2020

You probably have to merge the two calculations in one big set of formula. Direct access to another column doesn't work as far as I know...

JenDe1Autor
Level 2
October 16, 2020

Thank you @Manuel Bause‚ ! I ended up adding everything into one column and it does work. Thanks for pushing me in that direction!