Show value in an expression

[#1]

I used the following formula but it isn't working as i hoped it would be:

=

if((sum(_namefield)/sum(_namefield))<0.3,Red(),Black())

I want all values <0.3 to be in red but nothing is happening when i use the formula above.

Someone knows haw to solve my problem?

[rajni_batra]

sum(_namefield)/sum(_namefield)

i think u have mistaken it will return always one i think it should be

sum(_namefield)/total sum(_namefield)

[#3]

Maybe i should have been more clear.

The first 'namefield' isn't the same as the second.

Lets assume the first one is 10 and the second one is 100

Take the formula above into account and the result should be 0,10 and should turn red of course.

That last part isn't happening.

Do you need more info?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

The expression you wrote will always return "1", because it is always dividing the value of each cell into itself. You might mean

=if(sum(_namefield) / sum(TOTAL _namefield) < 0.3, Red(), Black())

That will divide the value in each cell by the value of the entire column.

Hope that helps.

Miguel

[rajni_batra]

can u post demo values

[whiteline]

svangrimbergen,

Your sums are the same.

I understand that you expects something different but don't understand what.

Could you discribe, where you use this expression and what result you want to achieve.

[sreenivas]

if(Sum(_namefield)/Above(Sum(_Namefield) < 0.3, Red(), Black())

[whiteline]

=if(Sum(_namefield)/Above(Sum(_Namefield)) < 0.3, Red(), Black())

[#9]

Thanks Miguel. It works!