Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would put some releases as negative. with this rule is doing at all and not only with the 'C' claims.
IF (CXBDEC = 'C', VLRRAT, VLRRAT * -1) AS [BALANCE CASH]
Its somehow the transformer fix it?
Translated with Google Translate - Qlik Community Administrative Team
gostaria de colocar alguns lançamentos como negativos. com essa regra está fazendo em todos e não só com os créditos 'C'.
IF(CXBDEC = 'C', VLRRAT, VLRRAT *-1) AS [SALDO CAIXA],
Tem como de alguma forma no transformador corrigir isso?
Please post sample data and expected result.
Regards
Marco
If( Index( 'CXBDEC' , CXBDEC) , -1 , 0 )
This will check if the field CXBDEC is equal to any of the letters C, X, B, D, E, C and return negative if so and return 0 if not.