3 Replies Latest reply: Feb 21, 2018 9:07 AM by ankit Jha RSS

    Relative percentage

    ana luna

      Hello, I need the formula to calculate the relative percentage as shown in the %Relative image.

      Can you help?

      Thanks.Relative.JPG

        • Re: Relative percentage
          Liron Baram

          hei

          see the attch example

            • Relative percentage
              ana luna

              Perfect!!!

              Thank you.

              • Re: Relative percentage
                ankit Jha

                I have a problem statement. 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 Txn_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 you help here