$(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

EVTIM is throwing #ERR

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2017 at 09:18 AM

    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)]

    Add comment
    10|10000 characters needed characters exceeded