10 Replies Latest reply on Feb 26, 2016 9:32 PM by Biju J

    Calculate percentage

    Biju J

      I have view like

       

      name   column1   column 2          Column3 %((column2/colum1)*100)

      A          32                   29                   

      B           60                    56

      C            42                    36

       

      How to create this new calculated field ( this is a derived calculation)

       

      Newbee here

        • 1. Re: Calculate percentage
          Mark Fraser

          Hi Biju

           

          At its most basic, you'd just do this

          But it will depend on how you derive the figures in column 1 and 2.

           

          Cheers

          Mark

          1 of 1 people found this helpful
          • 2. Re: Calculate percentage
            Biju J

            Hi Mark,

             

            Thanks, I tried the calculated field but didn't worked. What I need is to calculate on top this view

            something like

             

            select column1 ,column2, (column1/column2)*100 (select column 1,column2 from ......)

             

            Is it achievable?

            • 3. Re: Calculate percentage
              roland.latsch

              What exactly isn't working with the mentioned calculation?

              Can you post a screenshot of what you have so far?

              • 4. Re: Calculate percentage
                Mark Fraser

                Hi Biju

                 

                Its certainly possible to reference an existing calculation in another, you just need to use its name.

                here is create 2 new fields, column 1 and 2, i am using fixed integers, but it could be another field

                 

                calc1     Column1 = 1+2

                calc2     Column 2 = 4+1

                 

                i then reference these new fields in my calculation

                calc3     (column2/column1)*100

                 

                So, you would calculate the child items first (in my example column 1 and 2)

                and then add the parent calculation (coulmn2/column1...)

                 

                Start with something small and easy (maybe mock something up in Excel), be sure to stop and check the results at each stage before doing the next, otherwise if you get to the end, and find a problem you wont know where it is!!

                 

                Cheers

                Mark

                • 5. Re: Calculate percentage
                  Biju J

                  Yup got it it was some aggregation I will give you sample data

                   

                  column1       type    

                  january        renewed

                  december   expected

                  january        renewed

                  january       expected

                  ---

                  so my result pane is

                  like

                                      renewed      expected   percent

                  january              2                    1        (expected/renewed )*100

                  december          0                    1         (expected/renewed )*100

                   

                   

                  This is how the data is I tried the column names but for this I think it won't work right. I need to do some aggregation in calculated column right?

                  • 6. Re: Calculate percentage
                    roland.latsch

                    i have build a small workbook based on your example data.

                    I hope it helps.

                    1 of 1 people found this helpful
                    • 7. Re: Calculate percentage
                      Mark Fraser

                      i have build a small workbook based on your example data.

                      Don't keep us in suspense!

                      Could you attach it, please?

                      • 8. Re: Calculate percentage
                        roland.latsch

                        Can't you see it? As you can see on my screenshot it is attached to my post.

                        Maybe it has to be moderated first?

                         

                        att.PNG

                        1 of 1 people found this helpful
                        • 9. Re: Calculate percentage
                          Mark Fraser

                          Sorry Roland, my fault.

                          I was reading the thread via my Inbox, and attachments don't seem to display.

                          In order to see your attachment, i needed to open the whole thread.

                           

                          I took the liberty of marking your response (with the attachment ) as correct as I believe it answer's Biju's query. Good work.

                           

                          Cheers

                          Mark

                          • 10. Re: Calculate percentage
                            Biju J

                            Thanks a lot guys