on 10-13-2014 6:12 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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])
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.