I have a formula and I want to put headings next to my formula

[tazibc]

I have created a formula based on a condition both results are the same its a simple % formula. If I want to put a condition where :-
if {@Controlled / Uncontrolled %}=100 and {@Controlled / Uncontrolled %}=100 then "Controlled" else if {@Controlled / Uncontrolled %}=100 and {@Controlled / Uncontrolled %}=100 then "Uncontrolled";

so if both percetages = 100 I want to display the following words:-

controlled 100%
uncontrolled 100%

is this possible

 

[CR85user]

Your formula above is somewhat confusing as you are stating that if

{@Controlled / Uncontrolled %}=100 and {@Controlled / Uncontrolled %}=100

then it should state

'Controlled'

failing that it should display

'Uncontrolled'

if the same condition is met...

Where are you getting the percentage figure from - is it a running total / summary / formula?

Let us know and I am sure we can guide you in correctly getting the result you want...

Something similar to:

If {#percentage1} = 100 and {#percentage2} = 100 then 'Controlled' else 'Uncontrolled'

Please take some time to read the faqs and help sites available to aquaint yourself with common formulas usage.

'J

CR8.5 / CRXI - Discovering the impossible