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?

------------------------------
Ryan Barstow
------------------------------

#CognosAnalyticswithWatson

Hi,

Your first expression is using the _add_days() function to add -8 days to the current date - giving you your previous week date. There is also an _add_years() function - you could use that instead, to add -1 years to the current date - this should give you the previous year.

Cheers!

MF.

------------------------------
Mark Fry
Technical Consultant
------------------------------

Mark, first and foremost.  Thank you hugely for replying.  I will be frank and honest, I am a novice at all of this.  I mean my first expression there was self taught and took nearly a week to figure out by myself.

That being said I keep running into a parsing error whenever I try to write it.  Any help on writing it, in your mind the way you think it would work best.  Would be greatly appreciated.

------------------------------
Ryan Barstow
------------------------------

Original Message:
Sent: Tue March 29, 2022 09:26 AM
From: Mark Fry
Subject: Same time Last year?

Hi,

Your first expression is using the _add_days() function to add -8 days to the current date - giving you your previous week date. There is also an _add_years() function - you could use that instead, to add -1 years to the current date - this should give you the previous year.

Cheers!

MF.

------------------------------
Mark Fry
Technical Consultant
------------------------------