Hi,
I am have problems with my row amounts when using set analysis and dimensions.
![Trich_0-1677171177473.png Trich_0-1677171177473.png](https://community.qlik.com/t5/image/serverpage/image-id/101238i6614D7E8CE974723/image-size/medium?v=v2&px=400)
So the formula for % Total AV Test 2 . It has percent in the name since working toward dividing. This is the correct total
if(vMeasureTimeframe='Last 12 Months'
,sum({<[Cycle Date]={"$(=Max([Cycle Date]))"},IssueDate={">=$(=vMinIssueDate)"}>} Total Contract_FundValue)
,sum({<[Cycle Date]={"$(=Max([Cycle Date]))"}>} Total Contract_FundValue)
)
Now when I try to break out this total across the dimension Rider_Type_BuyUp it not getting amounts that add up to total.
My formula for %Total AV Test 1 is as follows
sum(aggr(if(vMeasureTimeframe='Last 12 Months'
,sum( {<ProductType={'FIA'},[Cycle Date]={"$(=Max([Cycle Date]))"},IssueDate={">=$(=vMinIssueDate)"}>} Contract_FundValue)
,sum({<ProductType={'FIA'},[Cycle Date]={"$(=Max([Cycle Date]))"}>} Contract_FundValue)
),Rider_Type_BuyUp))
I also tried to wrap the sum aggr around each if condition and got the same result. So, I want the column % Total AV Test 1 to equal the % Total AV Test 2.
Here how the formula for % Total AV Test 2 reconciles
![Trich_1-1677172149283.png Trich_1-1677172149283.png](https://community.qlik.com/t5/image/serverpage/image-id/101240i69A3F1FC40375C97/image-dimensions/737x35?v=v2)
Any help would be appreciated!