Hello,
I have 2 measure variables in my dataset. Lets call them var1 and var2. I would like to create a very simple calculated item: var1 / var2 The problem is when I make this calculation, it gives me 0s for all te records, but both var1 and var2 variables having values greater than 0. So this calculation is obviously wrong. Example: var1: $20,000.00, var2: $5,000.00 ratio should be 400%, but it gives 0% To try to debug, I created a calculated item, using only var1, and I was seeing the values of var1 correctly. Same for var2. The problem arises when I added / between two of them. I have no idea why it could be happening, please let me know if you have any ideas how to fix that. One point that might be relevant, the measure variables I am using, var1 and var2 are also calculated items I created on VA. Thank you!
... View more