Multi value error in Webi 4.0

[former_member640919]

Hi,

We have a report with output

Empno, Empname, DCPP percantage, DCPP Dollar Amount

DCPP Dollar Amount is dependent on DCPP Percentage, DCPP Dollar Amount Calc and Max DCPP Contribution Prompt

I am getting multi value for DCPP Dolloar and getting values for an employee for DCPP Percentage, DCPP Dollar Amount Calc and Max DCPP Contribution Prompt

DCPP Percentage=Sum(If ([Infotype]="0169"  And [Benefit Plan] InList ("DCPP"; "DBPP")) Then (If ([Pretax Saving])>0 Then[Pretax Saving] Else [Posttax Saving]) Else 0)

DCPP Dollar Amount calc=[EMPL ADMIN - Salary Yr] *[DCPP Percentage] *12

Max DCPP Contribution Prompt=ToNumber(UserResponse("Enter Value of Max DCPP Contribution ($Amount):"))

DCPP Dollar Amount=Sum(If([Benefit Plan]) ="DCPP"  Then If([DCPP Dollar Amount calc])>=[ Max DCPP Contribution Prompt] Then [ Max DCPP Contribution Prompt] Else [DCPP Dollar Amount calc] ElseIf ([Benefit Plan]) ="DBPP" Then If( [DCPP Dollar Amount calc]) >=[Max DBPP Contribution Prompt] Then [Max DBPP Contribution Prompt] Else [DCPP Dollar Amount calc])

thanks

[Former Member · Accepted solution]

Hi Jyothy,

There are many discussions on SCN on #Multivalue Error

I suggest you search more before creating a discussion.

Regards,

Ashvin

[former_member640919 · Accepted solution]

Hi Ashvin,

I have  tried all the multi value error posts before creating this post and tried all the posts which you have specified, but nothing seems to work.

Actually, For an Employee we have Benefit plan  as both DCPP and DBPP. i.e. The employee has two records, but I have to display as one record. I am using The below formula and getting multi value for this formula.

DCPP Dollar Amount=

Sum(If([Benefit Plan]) ="DCPP"  Then If([DCPP Dollar Amount calc])>=[ Max DCPP Contribution Prompt] Then [ Max DCPP Contribution Prompt] Else [DCPP Dollar Amount calc] ElseIf ([Benefit Plan]) ="DBPP" Then If( [DCPP Dollar Amount calc]) >=[Max DBPP Contribution Prompt] Then [Max DBPP Contribution Prompt] Else [DCPP Dollar Amount calc])