- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
what i am doing seems simple enough but not able to get a value displayed.
i have a table with sales, salesdate(this is a normal date field with month day and year)
their is one record for each day.
i want to show in a table objecty , current day and previous day sales and of course Diff and % Diff.
the relative period calculation seems that it would allow me to create a new measure for yesterdays sales.
simply....
RelativePeriod(_Sum_, 'sales'n, 'salesdate'n, _Inferred_, -1, _Full_, {Date})
cannot get any value to display.
thanks for your help
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
i submitted a bug request.
sas does not call this a bug even tho the documentation states it works.
they call it a feature request.
sas support has put my name in as a requestor of the feature.
problem not resolved but in the queue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
from everything i read and have seen, this should work, but doesnt.
noone seems to be able to resolve the issue or maybe noone needs yesterdays measures.
the documentation states quite plainly what this feature does, how to code it and what it displays.
i will report as a bug to sas support.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
i submitted a bug request.
sas does not call this a bug even tho the documentation states it works.
they call it a feature request.
sas support has put my name in as a requestor of the feature.
problem not resolved but in the queue.