Skip to main content

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.

Hi @Mangroliya Bhagyashree 

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


Lucid Software Inc. Supplemental Community Terms