Data being displayed using background colour in expession.

[#1]

Hi

[raghavsurya]

can u pls elaborate your question

[#3]

Sorry

Will post correctly

I have a Table similar to below

Type  Objective   Value 

A             2            3       

B             2            1        

C             1            1

TOTAL     2            1.66

The value column contains a calculated percentage. The objective total is displayed using Max Of Rows.

I have set the background colour in the expression to be

if(sum(Value) <= sum(Obective), green(), red()).

The if statement sees the Total Objective as 5 rather than the the displayed value. It is possible for it to look at the dispalyed value rather than the sum?

[raghavsurya]

Hi,

Try using RangeMax functionality.

if(Sum(Value)<=RangeMax(Objective),Green(),Red().

Regards,

Raghav

[kaushiknsolanki]

Hi

    As per my understanding of your problem i am here by sending you an example

Regards,

Kaushik Solanki

[#6]

Hi

This does quite work but I may have not been clear initially. I hae re attachd the document highlighting what is happening.

The total is a calculated expression and the objective total displays the MAX value of that column. The value column is showing in Blue because it is less than the sum of the objective which is 7. However I want to look at the displayed value of 2 so it shows in red.

Apprieciate your help so far.

[#7]

I have posted the example again with RangeMax and it does the same as before.

Thanks

[raghavsurya]

Hi,

Use Only Max instead of Rangemax.  Its working for me.

Regards,

Raghav

[#9]

Thank You

It works in the demo doc but still does not quite work in mine. I will see if I am missing something.

[montubhardwaj]

HI,

Please find the attached file.Hope this is helpful. I have made few chanegs in the attached by Kaushik.

Regards,

Sharma