Using the above syntax, I was able to calculate the percentage complete between two dates.
I’m looking now to calculate the percentage complete between two dates if the issue status is in progress and if it’s Done then it should be 100%. However my following Syntax is causing an error. What am I doing incorrectly? Thanks!
CASE
**WHEN ** [Measures].[Issue Status] = “Done” THEN "100%" ELSE (DateDiffDays(Now(),[Measures].[Issue Actual Start Date])) / (DateDiffDays([Measures].[Issue Go-Live Date],[Measures].[Issue Actual Start Date]))
It has the closure “END” for the CASE WHEN expression
It returns 1 when the status is “Done”
It has the val() in case the expression doesn’t recognize the value returned after ELSE
CASE WHEN
[Measures].[Issue Status] = "Done"
THEN 1
ELSE
val((DateDiffDays(Now(),[Measures].[Issue Actual Start Date]))
/
(DateDiffDays([Measures].[Issue Go-Live Date],
[Measures].[Issue Actual Start Date])))
END
when i use the below formula in eazybi i get the right % complete, however, it is showing a task over 100% complete if the actual trend date has passed. How do i ensure it only reads 100%?