|
-
May 6th, 2008, 05:33 AM
#4
New Member
Re: Formula Help...! Crystal XI
Yes for that do these steps
1) on report make a group by with IDNO
2) create formula like 'VLWPCounter' and write down
if {LEAVECODE} = "VLWP" then
SUMOFLEAVE_DAYS
else
0
3) create another formula like 'SLWPCounter' and write down
if {LEAVECODE} = "VLWP" then
SUMOFLEAVE_DAYS
else
0
4) Create Summary field on SUMOFLEVE with group total (It will gives the total leaves)
5) and then place them these two formula fields in group detailed section
6) create group wise summary fields and name it like total VLWP and total SLWP
7) then after that supress the setailed section
By doing this you can get the expected result
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|