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
Original Message:
Sent: Mon March 28, 2022 10:16 AM
From: Ryan Barstow
Subject: Same time Last year?
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