Thanks, I tried the calculated field but didn't worked. What I need is to calculate on top this view
select column1 ,column2, (column1/column2)*100 (select column 1,column2 from ......)
Is it achievable?
What exactly isn't working with the mentioned calculation?
Can you post a screenshot of what you have so far?
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
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!!
Yup got it it was some aggregation I will give you sample data
so my result pane is
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?
i have build a small workbook based on your example data.
Don't keep us in suspense!
Could you attach it, please?
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.
Thanks a lot guys