Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not working.... All showing 0 value
Did you open the file I attached? I seem to be having no problems at all
No it still is not working for me.
Is this a screenshot from the file that I attached?
No I tried to apply the formula shared by you in my file. But in my file this does not seem to be working.
I am going to let you figure out your own mistake by just showing an image
Mistake corrected. Thanks!!
The data is still not correct. check the %ages
I guess it might have gotten lost in my post... but you cannot have 'Relative' option checked... Try removing that
Its works!!! Thanks!!
Superb... I am glad that we can finally agree that it works