Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

error, derived Items

Accepted Solution Solved
Reply
SAS Employee
Posts: 8
Accepted Solution

error, derived Items

Hello.

I make a the difference between the value for the current time period and the value for the  previous time period,  with a  item
derived (Difference from Previous Period)  and   drill down using an item "" Time Hierarchy ", when this  Time Hierarchy has  a  source  of   type
datetime,  generates the following  output

Operation performed >>

Add the years 2015 + 2016

92 + 93 = 185

Result for 2015  = 92  - 185  =  -93

Result for 2016 = 93 - 185   =  -92

DerivedItems.png

What is the cause  at  this error  ?


Accepted Solutions
Solution
‎05-19-2016 04:13 PM
SAS Employee
Posts: 8

Re: error, derived Items

 

Hello 

 

The workaround prior to 7.1 is to base the calculation on a date and not a datetime.

 

Defect  http://sww.sas.com/ds/DefectsSearch/S1075/S1075775.html 

View solution in original post


All Replies
Solution
‎05-19-2016 04:13 PM
SAS Employee
Posts: 8

Re: error, derived Items

 

Hello 

 

The workaround prior to 7.1 is to base the calculation on a date and not a datetime.

 

Defect  http://sww.sas.com/ds/DefectsSearch/S1075/S1075775.html 

Post a Question
Discussion Stats
  • 1 reply
  • 241 views
  • 0 likes
  • 1 in conversation