Skip to Content
avatar image
Former Member

Choosing last pay ending date and multivalue error

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 23, 2018 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.

    Add comment
    10|10000 characters needed 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, 2018 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?

    Add comment
    10|10000 characters needed characters exceeded