Weekly , Monthly , Yearly Compare Help

[amit_saini]

Hi Folks,

I'm having below expression:

OEE=

if(sum([Act Planned Production Hours]) = 0, avg([Act OEE]),

sum([Act OEE]*[Act Planned Production Hours])/sum([Act Planned Production Hours]))

Now value of above exprssion I have to compared based on last week , last month , last Year

For example :

if (Week 38 value of OEE is > last week i.e . 37 ,'▲','▼')

similarly if (Sep value of OEE > Aug Value of OEE,'▲','▼')

and if (2016 OEE > 2015 OEE ,'▲','▼')

Result should be something like below:

Any Suggestions???

Thanks,

AS

[shraddha_g]

check date format of WeekStart() and WeekEnd() is same as that of %DATE_Key