Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Total Months into Quarter? Post Reply Post New Topic
Author Message
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet Topic: Total Months into Quarter?
    Posted: 12 Jul 2018 at 5:57pm
There's a table that contains history by year by month per person.

I need to total the months and show them in quarters

The Months are on 01 - 12 (text)
One step maybe to do the following to convert it to number:
ToNumber(Month)

Though may not be necessary and use IN (["01","02","03"]), etc ...

Need to have the total wages for Months 1-3 as Q1, Months 4-6 as Q2, Months 7-9 as Q3 and Months 10-12 as Q4

I have Q1 - Q4 Formulas with so far
{PR_EmployeeTaxHistory.CalendarMonth} IN (["01", "02", "03"])

I am unsure how to add to this so I get a some of GrossWages only for 01-03, etc ...?

This is part one of two but need to obtain this first.


2nd part of the report need is
So an employee’s cumulative salary throughout the calendar year should be applied to the max limit.

For example if a person makes $5,000 in the first quarter, then $5,000 should be in the Unemployment UILimit in the first quarter report.

And then they make $5,000 in the second quarter, then $5,000 should be in the Unemployement UILmit in the second quarter report.

And then they make $5,000 in the third quarter, then there should be $2,600 in the Unemployment UILimit in the third quarter report.

And then they make $5,000 in the fourth quarter, there should be $0 in the Unemployment UILimit in the fourth quarter report. (Because they hit the limit of $12,600 in the third quarter for the calendar year)


Edited by techsupport - 12 Jul 2018 at 6:46pm
____________________
Thank you very much!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.