Skip to main content
Level 3
May 19, 2020
解決済み

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

  • May 19, 2020
  • 3 の返信
  • 780 ビュー

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?

このトピックへの返信は締め切られました。
ベストアンサー 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 の返信

HeatherLa2作成者回答
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

Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
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!