Measurement to sum Actua Effort for yeach years starting from Current_Date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Measurement to sum Actua Effort for yeach years starting from Current_Date

Dears,

i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years:

  • Sum of Actual effort when Year(Completion Date) = Year(Current Date)
  • Sum of Actual effort when Year(Completion Date) = Year(Current Date)-1
  • Sum of Actual effort when Year(Completion Date) = Year(Current Date)-2

This is the acual formula:

FILTER(SUM("Completion Information"."Total Actual Effort") USING (YEAR("Post-Active Details"."Completion Date") = YEAR(CURRENT_DATE)-1))

The sum is working but it's actually summing all actual efforts, and it's not summing based on YEAR("Post-Active Details"."Completion Date") = YEAR(CURRENT_DATE)-1.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!