Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I want to create a calculated column which will calculate percentage over another calculated column. E.g.:

I have three columns: ColA, ColB (=ColA-12%), ColC(=ColB-10%).

The problem is, that ColC is not calculated as I wish. I suppose, that it is because it uses another calculated colum.

In the real environment the formulas are more complicated over more columns.

Is there any option how to hack this?

thanks.

share|improve this question
    
Why don't you replace ColB in ColC formula wiht ColB formula like ColC(=(ColA-12%)-10%) –  Arsalan Adam Khatri Jan 26 '13 at 15:16
    
I can do this that's true. But I'm trying to find out if there is exists another way. In our case ColB is used in another calculated columns and ColB formula can be changed in time. It means, that i will need to change it in all another columns. –  zosim Jan 26 '13 at 15:23

1 Answer 1

up vote 1 down vote accepted

Why don't you replace ColB in ColC formula wiht ColB formula like ColC(=(ColA-12%)-10%)

Also, if you need help in calculating percentages.. The Calculate Columns actually use Microsoft Excel based formula's so you can take help from here:
How to do percentages in Excel

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.