Skip to Content

Choosing last pay ending date and multivalue error

Jan 23 at 04:47 PM


avatar image
Former Member

I am using CGI Infoadvantage BI launch pad

SAP BusinessObjects BI Platform 4.1 version

I'm fairly new at BI. I'm working on an overtime report whereas I want one column to show the hours for the most recent pay ending and the second column to include all pay periods. I couldn't figure out how to pull out the last pay period so I created a variable with the last pay period manually entered. If the person has had hours in a prior period it will give me a multivalue error. My variable is:

If ( [ pay period end date] = '10/21/2017' ; [var-OT Hours]; 0)

Var-OT Hours =

sum ( [input amt]/60) where [Var - OT Ind] = 1)

Variable indicator is marking records with a 1 if the object code matches one in the list.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 23 at 08:11 PM

That did not work. I think it is because it is in a crosstab table. In the raw data each day is available, so although there are only 2 pay periods in this example, there are actually up to 14 possible entries.

capture.jpg (51.2 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Pay period end date is included in the cross tab?

Change the qualification of Var-OT hours variable from measure to dimension and check..multivalve error is coming because there are more than one value for one record..might be some null value.drag additional dimension and see what is actually impacting.

Jan 23 at 06:13 PM

try this.

If ( [ pay period end date] = '10/21/2017' ; sum([var-OT Hours]); 0)

if it will not work can you share the webi table screeshot?

10 |10000 characters needed characters left characters exceeded