Formula for Location Levels - US/PR
Summary
Custom formula if location level 2 is Puerto Rico, it will return Puerto Rico and if any other value, return other valueContent
Our location structure is set up as Level 1 = Country and Level 2 = State/Province.
Because we want to report on Puerto Rico at the country level, we built a custom formula in BO to make the conversion for us. Essentially, the formula would look at location level 2 and if it was Puerto Rico, it would return Puerto Rico and if it was any other value, it would return that value.
How do I create a similar formula in OBI Reporting to accomplish this same thing?
0