How do I refer to specific child row.

Hi, I need help to do some calculations on daily basis (columns 01 to 31) at each parent level . For e.g In below screenshot If I want to calculate difference between (a child rows) "Total Vulnerability count" - "Total New Vulnerability Count" every day using generic formula so that I can apply at each parent level. what is the best way to do it? Thanks in advance.
Best Answer
-
Hi @PKotha
Try this:
=INDEX(CHILDREN(), MATCH("total vulnerability count", CHILDREN($Application@row), 0)) - INDEX(CHILDREN(), MATCH("total new vulnerability count", CHILDREN($Application@row), 0))
It searches within the children of this current row in the "Application" column to find the matching "value" and bring back the number from that row in the current column (e.g. 01), subtracting one from the other.
I've put in an absolute reference ($) so you can drag this formula across the entire row and it will stay looking at your primary column for the "value".
Let me know if this works for you!
Cheers,
Genevieve
Need more information? ๐ | Help and Learning Center
ใใใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao!๐ | Global Discussions
Answers
-
Hi @PKotha
Try this:
=INDEX(CHILDREN(), MATCH("total vulnerability count", CHILDREN($Application@row), 0)) - INDEX(CHILDREN(), MATCH("total new vulnerability count", CHILDREN($Application@row), 0))
It searches within the children of this current row in the "Application" column to find the matching "value" and bring back the number from that row in the current column (e.g. 01), subtracting one from the other.
I've put in an absolute reference ($) so you can drag this formula across the entire row and it will stay looking at your primary column for the "value".
Let me know if this works for you!
Cheers,
Genevieve
Need more information? ๐ | Help and Learning Center
ใใใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao!๐ | Global Discussions
-
Prefect, it worked. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!