Calculate difference between two dates?

Justin Hester
Justin Hester Customer
Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board First Comment
in Platform

Hi there,

I am trying to calculate the difference between two dates as part of a dataflow, which has previously worked, but is no longer working after the 12.6 update.

This is a smaller subset of a larger calculation, but have narrowed down the issue to be related to the dates.

You can note below the cubes have different dimensions, but effectively meaning the FY end date is static for all records, as shown in the layout export below.

Any help would be much appreciated.

Cheers,
Justin

image.png
image.png
image.png

Tagged:

Accepted Answer

  • Leone Scaburri
    Leone Scaburri Employee
    Level 300: Expanding Board in Your Organization First Anniversary First Comment Level 100: Foundations of Building in Board
    Answer ✓

    Hello @Justin Hester,

    would be relevant to know the structure of your target cube (f: Labour Calc - LSL) and how you configured extend options.

Answers

  • Justin Hester
    Justin Hester Customer
    Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board First Comment

    Hi Leone,

    Thanks for your questions - you've pointed me in the right direction!

    I had a dimension mismatch, after implementing a technical key to reduce dimensions.

    I fixed this through introducing a temporary cube (now using "Years of Service" rather than "Labour Calc - LSL" for this calc) to calculate the date movement using the original dimensions, and then using that calculated field in the full calculation which is working as expected now.

    I've included screen shots below.

    image.png
    image.png

    Thanks again,

    Justin

  • Leone Scaburri
    Leone Scaburri Employee
    Level 300: Expanding Board in Your Organization First Anniversary First Comment Level 100: Foundations of Building in Board

    Great! Thanks for sharing your feedback.

Categories