I am attempting to sum a field in my org chart data (“Total Paid FTE:”) whereby I would like the total FTE of the shapes downstream from a particular shape. I am using =SUM(DOWNSTREAMDEEP."Total Paid FTE"), which is working only on shapes with shapes reporting to them. Those shapes which have no ‘downstream’ are showing 0 as the result. Is there an IF function I can build in to show the FTE values of those shapes which terminate with no direct reports? In the example below, there are FTE in all of the org units showng 0 values.
Answer
Sum of values in Org Chart
Best answer by Humas1985
Hi
Can you try the below formulae and see - you could be able to meet your needs.
=IF(SUM(DOWNSTREAMDEEP."Total Paid FTE") > 0, SUM(DOWNSTREAMDEEP."Total Paid FTE"), THIS."Total Paid FTE")
You may find a related post in the community discussing Org Charts and Formulas to be helpful. Referencing this post may provide valuable insights and ideas that could assist you in finding a solution
Summing Employee Salaries in Org Chart in Lucidchart | Community
Sum of values in Org Chart | Community (lucid.co)
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
+24- Lucid Legend Level 10
- Answer
Hi
Can you try the below formulae and see - you could be able to meet your needs.
=IF(SUM(DOWNSTREAMDEEP."Total Paid FTE") > 0, SUM(DOWNSTREAMDEEP."Total Paid FTE"), THIS."Total Paid FTE")
You may find a related post in the community discussing Org Charts and Formulas to be helpful. Referencing this post may provide valuable insights and ideas that could assist you in finding a solution
Summing Employee Salaries in Org Chart in Lucidchart | Community
Sum of values in Org Chart | Community (lucid.co)
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
