Set Analysis

[dunnalahk123]

Hi,

I am trying write on expression in set analysis.

=Sum({$<Distinct [ASDP Name] =>}[CSNUM])

=(AGGR(SUM(DISTINCT [CSDEN]),[ASDP Name]))

basically i need For Distinct ASDP Name what is the sum of NUmerator.

Can some one help me here.

Best Regards,

HK

[Anil_Babu_Samineni]

Expression seems not the correct syntax

=Sum({$<Distinct [ASDP Name] =>}[CSNUM])

Use this

=Sum({$<[ASDP Name] =>} DISTINCT [CSNUM])

Seems, second expression correct to me, Is there any wrong output?

[dunnalahk123]

Hi Babu,

Thank You.

But i need For Distinct ASDP Name i need sum of numerator.

Best Regards,

[Anil_Babu_Samineni]

Again Confused, And field looks like Character. How do you sum for Character. May explain bit more with sample data

[dunnalahk123]

Hi,

I attached APP above.

Best Regards,

[neelamsaroha157]

It would be easier if you can share sample data.

Can one CSDEN have multiple CSNUM??

[dunnalahk123]

HI,

For CS DEN is nothing but my Denominator or CSNUM  is nothing but my Numerator always it will be  1 or 0 it is my Calculated fields .

if you go to raw details tab For one ASDP NAME have mutiple rows.

So in piviot when i do sum for one ASDP Name it should be counted only once.

Best Regards,

[neelamsaroha157]

Check this out.

I didn't get what is the issue that you are facing but I have added multiple columns to reflect the result set.

Let me know if this helps.

[dunnalahk123]

Hi Neelam,

Thank you.

Basically when i collapse the pivot for AMS CSNUM should be 13 which is my Numerator and CS DEN will be 18 which is my Denominator.

So it's not working as Expected at this moment.

Best Regards,

[neelamsaroha157]

Check this out.