Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

WF Time in cube view

Originally posted by Dean Harper Hi all, Hopefully a simple one - is there a way to dynamically select the prior year comparable for a Cube view based upon the workflow. So Column 1 = T#WF ...
  • johnal67's avatar
    johnal67
    3 years ago

    Am I missing something easy with how to refer to the Workflow prior "year end" regardless of what month is current?  eg. (2022M5 compared to 2021M12, 2022M6 compared to 2021M12, etc).  Updated: solved my problem with T#YearPrior1(|WFYear|)M12