Expressão correta?

David_Almeida — Thu, 11 Aug 2022 16:24:17 GMT

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'))))

Re: Expressão correta?

Digvijay_Singh — Fri, 12 Aug 2022 02:58:33 GMT

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') )))

topic Re: Expressão correta? in App Development

Expressão correta?

Re: Expressão correta?