topic Re: Table and Text Object Value Mismatch in App Development

Table and Text Object Value Mismatch

sunitha_chellaiah — Fri, 29 Apr 2022 13:11:34 GMT

Hi,

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 — Fri, 29 Apr 2022 18:16:41 GMT

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 — Fri, 29 Apr 2022 18:22:07 GMT

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_chellaiah — Mon, 02 May 2022 06:22:58 GMT

Thank you for your response

sunitha_chellaiah — Mon, 02 May 2022 06:23:35 GMT

Thank you @rubenmarin , it's working.