Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 sunitha_chellai
		
			sunitha_chellaiHi,
I want to get sum of rows value as final value in my text.
Kindly see the below screenshot.
Here, what i want is 2.78%(25% column) to be displayed in text object. this 2.78 % i am getting by enabling total function as sum of rows.
to calculate 25% , I have used this formula
if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/count(TOTAL DISTINCT BRANCH_CLEAN))/100)
Thanks
 
                
            
         rubenmarin
		
			rubenmarin
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, you can try with:
Sum(Aggr(if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/count(TOTAL DISTINCT BRANCH_CLEAN))/100),Category,Branch))
 rubenmarin
		
			rubenmarin
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, you can try with:
Sum(Aggr(if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/count(TOTAL DISTINCT BRANCH_CLEAN))/100),Category,Branch))
 vish123
		
			vish123
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Sunitha,
please try this,
if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/aggr(count(TOTAL DISTINCT BRANCH_CLEAN),Category,Branch))/100)
hope this helps.
 sunitha_chellai
		
			sunitha_chellaiThank you for your response
 sunitha_chellai
		
			sunitha_chellaiThank you @rubenmarin , it's working.
