Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
Daniel,
0,7 should be 0.7