I have imported data and I need to sum a column of data if another column of data is = to specific text. Below is my initial formula but I keep getting an error.
=SUM(@"Annualized Cost") AND(x => x."Worker Status" = "Active"))
Answer
Sum column data and reference another column using formulas
Best answer by Richard Udell
Hi Elizabeth thank you for contributing to the Lucid Community. I'm happy to help troubleshoot your formula. Just to make sure we're on the same page please reference Lucid's Formulas documentation.
I understand you're trying to sum a column of data based on a condition in another column. I suggest rewriting the the formulas so the condition is inside the SUM function. The correct formula might look something like this:
=SUM(IF(@"Worker Status" = "Active", @"Annualized Cost", 0))
This formula will sum the "Annualized Cost" for rows where "Worker Status" is "Active".
If you're still encountering issues could you please provide a screenshot of your document that includes the formulas and data fields you're working with? This will help me understand your context better and provide more accurate assistance.
+8Hi Elizabeth thank you for contributing to the Lucid Community. I'm happy to help troubleshoot your formula. Just to make sure we're on the same page please reference Lucid's Formulas documentation.
I understand you're trying to sum a column of data based on a condition in another column. I suggest rewriting the the formulas so the condition is inside the SUM function. The correct formula might look something like this:
=SUM(IF(@"Worker Status" = "Active", @"Annualized Cost", 0))
This formula will sum the "Annualized Cost" for rows where "Worker Status" is "Active".
If you're still encountering issues could you please provide a screenshot of your document that includes the formulas and data fields you're working with? This will help me understand your context better and provide more accurate assistance.
+20Hi! I’m Micah from Lucid’s community team. 👋 I thought you, and any others who might come across this topic in the future, might be interested in Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!
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.
