$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

EVTIM is throwing #ERR

Apr 05, 2017 at 02:15 PM

33

avatar image

My Requirement is to Achieve 2016.JAN ( in T12 Cell) using EvTIM

I am referring form S12 it is deriving 2017.JAN ( to derive 2017.JAN I used "

=EVPRO(Application, "LE","ACT_YEAR")&"."&EVPRO(Application, "LE","ACT_MONTH")

I tried following :

1. EVTIM(Application,S12,-1) it is deriving : PYS.TOTAL

2. EVTIM(Application,S12,-2) it is throwing error #ERR

Checked for EVTIM(Application,S12,2) it gave correct value 2017.MAR

Please suggest why it is not deriving for -2

My Time Dimension sheet is as below :

Thanks in Advance

Sridhar

gfzuj.png (71.0 kB)
n1xyl.png (11.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member
Apr 11, 2017 at 04:23 PM
0

If I recall correctly, you will need to include the 2016 members in the same hierarchy as the 2017 values, so that it can trace backwards along the hierarchy using the negative values to find the 2016 month you require, since 2016 rolls up under the "Last Year" hierarchy node.

Share
10 |10000 characters needed characters left characters exceeded
IBM ADAM BPC Support Team Apr 12, 2017 at 09:18 AM
0

Thank you Daniel, As suggested I have added '2016' Year in Time dimension and included ' YEAR' in 'level' parameter ,it worked.

EvTIM(AppName,Member,Offset,Level) --------> [ EvTIM(AppName,S12,-1,YEAR)]

Share
10 |10000 characters needed characters left characters exceeded