topic created item does not make the calculation correctly in SAS Visual Analytics

created item does not make the calculation correctly

znhnm — Fri, 28 Jul 2023 11:02:22 GMT

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!

Re: created item does not make the calculation correctly

PaigeMiller — Fri, 28 Jul 2023 11:31:27 GMT

Show us your code. Show us the log. Show us a portion of the data.

Re: created item does not make the calculation correctly

acordes — Tue, 01 Aug 2023 07:55:29 GMT

You do not address correctly your problem.

Here at SAS communities when you do not get an answer within a few hours, it's not the community's lack of willingness to help or knowledge, it's about how YOU frame the problem.

So, in your case a screenshot of some rows of your table would be of great help.

I suppose that var1 and var2 do not occur in the same row, therefore the division has to be done via aggregated measure.

In the easiest case you could solve it by using the by_group sum operator within the division.

The magic of VA is its ease to summarize in a dynamic context.

When doing calculations you should always check first on detail level meaning that you need to go to row-level.