2 Replies Latest reply on Feb 16, 2016 1:06 AM by Sudhakar Dhamodharan

    Date field in Dimensions..unable to calculate it in measures

    Sudhakar Dhamodharan

      Hi All, I would request some one to guide me on this..i have a transaction sale date in dimensions. I need to calculate the number of days since the item sold. i have created a calculated field for current date as today(). i am facing difficulty in seeing the differences between the current date (in measures) and the transaction date (in dimension).

       

      I tried converting the transaction date type in dimensions from string to date or a number..but unable to succeed to bring it in measures or in the formula area.

       

      Can someone help me with this?

       

      -Sudhakar Dhamodharan