Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have an error in the paste expression.
code used: =IF((Sum({$<[COD_RETENCAO_IRRF]={'0588'},ANO_EMISSAO={'2022'}>} VAL_RET_TRIBUTO) / Sum({$<ANO_EMISSAO={'2022'}>} DIRF_0588) ) = 0,GREEN(),RED())
The intention is to divide the two sets of analyzes and if the result is equal to 0 the color in the table will be green,
Thanks
what error message are you getting? is it possible the denominator is 0? and you are certain the fields you used are all existing fields?
The code looks ok, the problem is not coloring right...
CODE: =IF((SUM({$<[COD_RETENCAO_IRRF]={'8045'},ANO_EMISSAO={'2022'}>} VAL_RET_TRIBUTO) <> SUM({$<ANO_EMISSAO={'2022'}>} DIRF_8045)),RED(),GREEN())
IF THE VALUE IS DIFFERENT BETWEEN THE TWO FIELDS ILLUSTRATED IN THE PRINT, YOU MUST PAINT RED OR GREEN