Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

Calculated Field Update help

Avatar

Level 4

Hello... I have a question on a calculated field we have that pulls data from two different fields into one with the following If statement:

IF(ISBLANK(CSBrand),BrandDepartmentNonAutomation,CSBrand)

We've added a third variable, which is if both CSBrand and BrandDepartmentNonAutomation fields are blank, then this field needs to be "PER"

How do I modify this If statement to reflect the added variable?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 7

HI Naushin,

Try this:

IF(ISBLANK(CSBrand),IF(ISBLANK(BrandDepartmentNonAutomation),PER,BrandDepartmentNonAutomation),CSBrand)

Hope that helps!

View solution in original post

2 Replies

Avatar

Correct answer by
Level 7

HI Naushin,

Try this:

IF(ISBLANK(CSBrand),IF(ISBLANK(BrandDepartmentNonAutomation),PER,BrandDepartmentNonAutomation),CSBrand)

Hope that helps!