Forum Discussion
cristianml
Post Prodigy
Post ProdigyCalculation 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 ...
amitchandak
Super User
Super User
cristianmlPost Prodigy
Post ProdigyHi 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.