0

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.

Improve this question
2
  • Why don't you replace ColB in ColC formula wiht ColB formula like ColC(=(ColA-12%)-10%)
    – Arsalan Adam Khatri
    Commented Jan 26, 2013 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
    Commented Jan 26, 2013 at 15:23

1 Answer 1

Reset to default
1

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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