Hi, I need implement the logic if one gcin have 1 limit id then show min of seller limit , but if 1 gcin have move than one limit id then it show some of distinct Seller limit and in total it show 89,420,000. I am using this formula to display seller limit =if(Aggr(Count(DISTINCT[Seller Limit ID]),[Seller GCIN])=1, num( ( min({<Month,Year,YearMonth,MonthNum,DateNum ={"$(vMaxDateNum)"},Flag_Lopt={1},Flag_Capt={1}>}[Seller Limit])),'#,##0'), num( ( sum(DISTINCT{<Month,Year,YearMonth,MonthNum,DateNum ={"$(vMaxDateNum)"},Flag_Lopt={1},Flag_Capt={1}>}[Seller Limit])),'#,##0'))
But formula show 44,710,000 in total because of different Seller code
The formula shared above does not work correctly. While it gives the correct total value (i.e., 89,420,000), in cases where the same GCIN (row2 and 3) and same Limit ID exist but with different Seller Codes, the value becomes 0.
Seller gcin,seller code, seller limit id, sellerlimit Above formula shared by you doesnot work because it give correct value in total i.e. 89,420,000 but one of the limit id value become 0 where gcin and limit id is same but seller code is different
