Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago

Calculation between same measure

Hi,

 

I need to do a calculation between number from a same measure. 

 

__Revenue / Workday 2 = [__Rev] / [__NWD]
 
 

 

 Per example: I need to do :
31.30 / 28.59  -1
28.59 / 25.16 -1 
25.16 /  23.54 -1 
an so on 

But this table doesn't have DATES. The FY & Q is a text format. And only have FY as a whole number and a quarter Column:

 

 

Any idea ?

 

 

 

Data Protection
General Comment
Interesting Links
Tips and Tricks
Tutorial Requests

2 Replies

    • 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.