Forum Discussion

amitchandak's avatar
amitchandak
Super User
4 years ago

cristianml ,

Try divide([__Rev] , [__NWD]) -1

 

or

divide([__Rev] - [__NWD],[__NWD])

  • cristianml's avatar
    cristianml
    Post Prodigy
    4 years ago

    Hi amitchandak ,

     

    Those numbers I showed in the screenshot are already the results of [__Rev] / [__NWD]

     

    What I need is to divide between that measure ..  So you can understand in code :

     

    Divide  >      ([__Revenue / Workday 2]) /  [__Revenue / Workday 2]) - 1

     

    I need this calculation one against previous one BUT it doesn't have DATE column. I explaIned this above.