Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Gsotaria de saber onde está o erro da expressão que estou utilizando em um campo.
If(dsc_grp_canal_dash = 'DIGITAL', SUM([qtd_transacao]), 'TOTAL DIGITAL',
If({<dsc_grp_canal_dash = 'DIGITAL' and dsc_canal_dash = 'WEB'>}, SUM([qtd_transacao]), 'DIGITAL INTERNET',
If({<dsc_grp_canal_dash = 'DIGITAL' and dsc_canal_dash = 'MOBILE PF'>}, SUM([qtd_transacao]), 'DIGITAL MOBILE',
If(dsc_grp_canal_dash = 'REDE', SUM([qtd_transacao]), 'BRANCHES'))))
Not sure but two things need to be corrected, first, remove '{>>}' characters from the if statements, they only make sense when set expressions are used, next, it doesn't make sense to me having both true and false condition in each if statement. May be you would need separate expressions from metric value and the metric label.
Metric value -
If(dsc_grp_canal_dash = 'DIGITAL', SUM([transaction qty]),
If(dsc_grp_canal_dash = 'DIGITAL' and dsc_canal_dash = 'WEB', SUM([transaction qty]),
If(dsc_grp_canal_dash = 'DIGITAL' and dsc_canal_dash = 'MOBILE PF', SUM([qtd_transacao]),
If(dsc_grp_canal_dash = 'NETWORK', SUM([qtd_transacao])) )))
Metric label -
If(dsc_grp_canal_dash = 'DIGITAL', 'DIGITAL TOTAL'),
If(dsc_grp_canal_dash = 'DIGITAL' and dsc_canal_dash = 'WEB', 'DIGITAL INTERNET'),
If(dsc_grp_canal_dash = 'DIGITAL' and dsc_canal_dash = 'MOBILE PF', 'DIGITAL MOBILE'),
If(dsc_grp_canal_dash = 'NETWORK', 'BRANCHES') )))