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.
Page 1 / 1
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
Reply
Create an account in the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
Log in to the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Login with SSO
Log in with Lucidor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
