Else command in dimension expression doesnt work

[Anonymous]

Hi All,

I am trying to use an expression for the table dimension format. After the second comma, it says that I am having an error in the expression. Does anyone have any idea why?

The expression follows:

=IF(SOMADOR_OP+SOMADOR_OS+SOMADOR_PEDIDO+SOMADOR_RISCO<=0,7*(COUNT(DISTINCT OP_OS)+COUNT(DISTINCT CONCATENADO_OP)+COUNT(DISTINCT CONCATENADO_PA)+COUNT(DISTINCT OP_RISCO))

  ,RGB(226,0,0),RGB(0,0,0))

I appreciate any help!

[sunny_talwar]

May be try this:

=If(SOMADOR_OP+SOMADOR_OS+SOMADOR_PEDIDO+SOMADOR_RISCO <= ((7/10) * (COUNT(DISTINCT OP_OS)+COUNT(DISTINCT CONCATENADO_OP)+COUNT(DISTINCT CONCATENADO_PA)+COUNT(DISTINCT OP_RISCO))), RGB(226,0,0), RGB(0,0,0))

[Clever_Anjos]

Daniel,

0,7 should be 0.7