Business Objects IF Statement

[former_member1029455]

I wonder if someone can help. I'm trying to create a variable to pull in the Costing Level for Staff into a report - I've created a sub query for the Costing and want to create a variable to pull in the Costing Information to my main Staff report.

The problem is there are multiple lines as Costing is split across Cost Centre, Project and Task which are all held in the same field name ie Cost Code:Posn. I want to say that for Cost Centre for example, for each employee if the Costing Level = Cost Centre then show value from the Cost Code Field.

I've merged the 2 reports on the Person ID field

Below is the formula I used but I'm getting #MULTIVALUE

=If([Monthly Cost Centre].[Level:Posn Costing] = "Cost Centre") Then [Monthly Cost Centre].[Cost Code:Posn] Else ""

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[ayman_salem]

Can you share a screenshot with sample data and incorrect and expected results so we can give you what may be the correct answer?

[former_member1029455]

Information attached - hope this helps.test-data-sap-screenshot.png