Reporting Question: Calculated field taking in two different fields for one response (nested IF statements, plus an additional value field) | Community
Skip to main content
New Participant
May 19, 2020
Solved

Reporting Question: Calculated field taking in two different fields for one response (nested IF statements, plus an additional value field)

  • May 19, 2020
  • 3 replies
  • 739 views

We have a request to produce one report that shows the following items:

Global Campaigns, Global Products, Region A, Region B, Region C

Value 1 = Region field with a dropdown of Global, Region A, Region B, Region C

Value 2 = Prioritization field that shows what the category they fall under.

So the desired end result for the calculated field would be: IF(Region="Global" AND Prioritization="Campaign","Global Campaign",IF(Region = A, "All A",""))

Desired result would look like this:

GLOBAL Campaign

GLOBAL Product

All A

All B

All C

How do I write out an "and" statement to pull two different values for one result within my nested IF statements?

Best answer by HeatherLa2

I think I've found the answer - and that I'd use a condition operator: &&

So IF(Region="Global"&&Prioritization="Campaign","Global Campaign",IF(Region=A,"All A",""))

Just wanted to follow up in case anyone else needs this type of thing. 😊

3 replies

kynabaker16
Employee
May 20, 2020

I echo Doug's congratulations and thank you for sharing your solution! I'm 100% sure someone else will want to know how to do this in the future!

Doug_Den_Hoed__AtAppStore
New Participant
May 19, 2020

Huzzah! Well done, Heather!

Oddly enough, I was just looking at a different && example a couple of hours ago, but failed to make the connection that it could also work in your case. Glad you got it going!

Regards,

Doug

HeatherLa2AuthorAccepted solution
New Participant
May 19, 2020

I think I've found the answer - and that I'd use a condition operator: &&

So IF(Region="Global"&&Prioritization="Campaign","Global Campaign",IF(Region=A,"All A",""))

Just wanted to follow up in case anyone else needs this type of thing. 😊