cancel
Showing results for 
Search instead for 
Did you mean: 

Format Question - Biz Objects

0 Kudos

I created a report with 8 data fields; I added a 9th column and included a formula that provides a 'status' for a given line item based on the data pulled within the report.  There are three seperate statuses; I then inserted a break which now seperates my three statuses into groups by that status, which is exactly what I want.  I can't figure out out to get a 'heading' above the three groups though.  Since I created a formula for the column of 'status', it won't let me drag that column heading to 'drop here to create a section' when I am in view structure mode .  I would simply like to be able to have a static heading above each section and have scoured the options/formatting/etc.  Is that possible to do?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

arijit_das
Active Contributor
0 Kudos

Why can't you create a dimension variable for Status and create section on that variable ?

0 Kudos

New to business objects; valid question you ask.  In my 'research', it is only a dimension value that allows for the section headers, which is why I havne't been able to figure this out.  That said, I guess I am not clear on exactly what a dimension variable is or how to do that.

To drive my status, I created the following formula in that column:

=(If Not(IsNull([Income])) And (([Address]) <> "To Be Determined") Then "***Needs Action***" ElseIf((([Address]) = "To Be Determined")) Then "No Action - Property TBD" ElseIf(IsNull([Income])) Then "No Action - Incomplete")

Thanks for the reply.

arijit_das
Active Contributor
0 Kudos

You can directly right click on the column and set as section.

0 Kudos

The column that I created that includes the formula to drive my status does not show 'set as section' as a choice; the other 8 data columns do show that as a choice. 

arijit_das
Active Contributor
0 Kudos

OK Got it.

Select the column and click on the create variable icon as highlighted below:

Give a name and make sure you select Dimension as qualification.

After that you will see that set as section option is active for that column.

0 Kudos

When I did that and pasted the formula in and hit the green check box, it changed the qualifcation back to measure from dimension and the set section was still not an option, because of the measure I assume.

arijit_das
Active Contributor
0 Kudos

Just change it to dimension and hit OK button. Does it create a dimension variable ?

0 Kudos

No, Dimension didn't stick.  I did, however, change the formula that I was using to drive the status.  One of the objects in the formula was a measure; I used a different object that was a dimension in the formula and it then, in turn, allowed me to create the section header.

Thanks for the help.

Answers (0)