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

Calculate percentage

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

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

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

What exactly isn't working with the mentioned calculation?

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

• 4. Re: Calculate percentage

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

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

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

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

Don't keep us in suspense!

• 8. Re: Calculate percentage

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?

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

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

Thanks a lot guys