Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I recreated the issue using two file uploads joined. 59,986 is correct sum of each resource multiplied by respective rate 59,010 is 420* 140.5 ( sum multipied by first rate in the list 140.5) TO get correct total on a tile, must always use set Sum By on Values under Properties. If visual property not set to sum by on…
-
@Sarah Beckwith-Oracle Thanks for your dva. I'm new to working with OAC also! I found my mistake. I didn't have ID set to treat as attribute. As a result, count(ID) came back as 1. When I set to attribute, I got the same results as you did. This works, however: Weighted SUM: sum(sum( WEIGHT by HOBBY, SEX, REGION ) ) So,…
-
This may work. In my testing, it worked with report filters for showing a tile with an amount on it. Weighted Sum: sum( sum(count(ID) * WEIGHT by HOBBY, SEX, REGION) ) I started with sum(count(ID) * WEIGHT by HOBBY, SEX, REGION). If you put this measure on a table with no attributes, you can see that it is shows 3 distinct…
-
Hmm. Seems to have fixed itself