Relative percentage calculation issue

[ankit_tikoo]

Hi Guys,

I have a problem statement for all. I am from payment industry. Let me explain my problem

Day  Failure/success reason    Txn_Count

1        No funds                           10

1       Cancelled                           20

1        Not approved  by bank      30

1        Successful                         40

Total                                            100

I have put a condition in the expression(Txn_Count) formula that Status='failed' to get below:

Day  Failure/success reason   Txn_count

1        No funds                           10

1       Cancelled                           20

1        Not approved                     30

I want count to be a relative percent i.e 10% for no funds, 20% for cancelled and 30% for not approved. This percent should be calculated with denominator 100 not 60

Also, This is for only on day. If there are many days and I select No funds failure reason, it should show relative share for all individual days.

1   No Funds   40%

2   No Funds  20%

3   No Funds  10%

Right now its showing 100% for all days. Can anyone help here

[ankit_tikoo]

Not working.... All showing 0 value

[sunny_talwar]

Did you open the file I attached? I seem to be having no problems at all

[ankit_tikoo]

No it still is not working for me.

[sunny_talwar]

Is this a screenshot from the file that I attached?

[ankit_tikoo]

No I tried to apply the formula shared by you in my file. But in my file this does not seem to be working.

[sunny_talwar]

I am going to let you figure out your own mistake by just showing an image

[ankit_tikoo]

Mistake corrected. Thanks!!

The data is still not correct. check the %ages

[sunny_talwar · Accepted solution]

I guess it might have gotten lost in my post... but you cannot have 'Relative' option checked... Try removing that

[ankit_tikoo]

Its works!!! Thanks!!

[sunny_talwar]

Superb... I am glad that we can finally agree that it works