Chart expression value in Text Object

[hamzabob1]

Hello friends

I have a expression in chart for service tax which I need to showcase in a text object.

I am able to achieve the same for INR amount, 

Kindly find the sample application attached.

Thanks in advance for your help!!

Regards

Hamza B

[hamzabob1]

Dear Anil,

I think your not getting wat i am trying to say you...

So let it be...

Regards,

Hamza

[Anil_Babu_Samineni]

May be stalwar1‌

[sunny_talwar · Accepted solution]

Not sure but may be this

=Num(Sum(Aggr(if(

  if(sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE)=0,

  sum({<S_SERVICE_DESCRIPTION={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE),

  sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE))=0,

sum({<S_SERVICE_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE),

  if(sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE)=0,

  sum({<S_SERVICE_DESCRIPTION={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE),

  sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE))), S_ZONE1, S_BRANCH_NAME, S_BOOKING_LEAD, S_AGENT_NAME, S_EMP_ID, S_REGION_CODE, S_LT_PROD_CODE, S_BF_NO, S_TRANSACTION_ID, DATE, S_CURRENCY_CODE, S_VALUE, S_DEPARTURE_DATE, S_END_TOUR_DATE, S_AMOUNT, S_EX_RATE)), '#,##0')

[hamzabob1]

Dear Sunny,

Thank you so much really appreciate your work..

thanks again,

Hamza