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
Level 3
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
  • 743 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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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

HeatherLa2AuthorAccepted solution
Level 3
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. 😊

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
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

kynabaker16
Adobe Employee
Adobe 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!