Difference Time

Options

Hi,

 

I want to calculate difference year like this, FC Admin - Choose Year(2018-2017=1). How to develop in board?

 

image

Answers

  • Alexander Kappes
    Options

    Dear Wahyu Nugraha,

     

    thanks for your request.

     

    For general, when you calculate the differences between Cubes, the calculation is based to the Dimensions the cube is belonging to.

     

    For your Case a DataFlow "FC-Admin" - "Choose Year" will bring the result -1 for 2017 and 1 for 2018 because each year is calculated separately.

     

    Perhaps our E- Learning portal helps you to understand how BOARD is working.

     

    regards

     

    Alexander Kappes