Skip to Content
0
Oct 13, 2014 at 05:12 PM

Multi value error in Webi 4.0

28 Views

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