Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Same time frame- Last Year

Status
Not open for further replies.

dinger045

Technical User
Mar 28, 2022
1
US
Hello,

I was wondering if anyone would be able to help me. I have two criteria that I want to be updated to do the same thing, but for the SAME TIME PERIOD the previous year.

One is a report that we have scheduled to tell us a count of something for the week previous (So we would need that but time period last year.:

IF ([Business Layer Standard].[Claim_Favorites__c].[Date_of_Loss__c] >_add_days(current_date, -8))
THEN ([Business Layer Standard].[Claim_Favorites__c].[Status_Count__c])
Else (0)


The Other is just a standard, give a me a count reference, but i need it to also put same time period last year. THis one I am unsure if we can do because it does not reference time in general.

[Business Layer Standard].[Claim_Favorites__c].[Status_Count__c]

Any thoughts?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top