FERRAMENTA FORMULA ZERANDO NO OUTPUT

A formula está retornando 0, sendo que não está passando no if... não sei se mudou a estrutura do if no alteryx, mas preciso de help....

ache o erro...

if [DS_PLANO] = "SMCRPMASS1GB" and [TP_SOLICITACAO] = "Alta" THEN [VALOR C/SVA] == "29,99"

elseif [DS_PLANO] = "SMCRPMASS2GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] == "34,99"

elseif [DS_PLANO] = "SMCRPMASS3GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "39,99"

elseif [DS_PLANO] = "SMCRPMASS6GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "44,99"

elseif [DS_PLANO] = "SMCRPMASS12GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "54,99"

elseif [DS_PLANO] = "SMCRPMASS15GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "64,99"

elseif [DS_PLANO] = "SMCRPMASS20GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "74,99"

elseif [DS_PLANO] = "SMCRPMASS30GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "89,99"

elseif [DS_PLANO] = "SMCRPMASS40GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "114,99"

elseif [DS_PLANO] = "SMCRPMASS60GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "134,99"

elseif [DS_PLANO] = "SMCRPMASS100GB" and [TP_SOLICITACAO] = "Alta" then [VALOR C/SVA] = "179,99"

elseif [DS_PLANO] = "SMCRPMASS200MB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "19,99"

elseif [DS_PLANO] = "SMCRPMASS1GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "29,99"

elseif [DS_PLANO] = "SMCRPMASS2GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "34,99"

elseif [DS_PLANO] = "SMCRPMASS3GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "39,99"

elseif [DS_PLANO] = "SMCRPMASS6GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "44,99"

elseif [DS_PLANO] = "SMCRPMASS10GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "49,99"

elseif [DS_PLANO] = "SMCRPMASS12GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "54,99"

elseif [DS_PLANO] = "SMCRPMASS15GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "64,99"

elseif [DS_PLANO] = "SMCRPMASS20GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "74,99"

elseif [DS_PLANO] = "SMCRPMASS25GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "84,99"

elseif [DS_PLANO] = "SMCRPMASS30GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "89,99"

elseif [DS_PLANO] = "SMCRPMASS40GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "114,99"

elseif [DS_PLANO] = "SMCRPMASS50GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "124,99"

elseif [DS_PLANO] = "SMCRPMASS60GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "134,99"

elseif [DS_PLANO] = "SMCRPMASS80GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "159,99"

elseif [DS_PLANO] = "SMCRPMASS100GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then [VALOR C/SVA] = "179,99"

else 0 endif

HELP.yxmd

Accepted answers

carlosteixeira

Boa tarde @Nilton_Alves

tenta com essa fórmula

if [DS_PLANO] = "SMCRPMASS1GB" and [TP_SOLICITACAO] = "Alta" THEN "29,99"

elseif [DS_PLANO] = "SMCRPMASS2GB" and [TP_SOLICITACAO] = "Alta" then "34,99"

elseif [DS_PLANO] = "SMCRPMASS3GB" and [TP_SOLICITACAO] = "Alta" then "39,99"

elseif [DS_PLANO] = "SMCRPMASS6GB" and [TP_SOLICITACAO] = "Alta" then "44,99"

elseif [DS_PLANO] = "SMCRPMASS12GB" and [TP_SOLICITACAO] = "Alta" then "54,99"

elseif [DS_PLANO] = "SMCRPMASS15GB" and [TP_SOLICITACAO] = "Alta" then "64,99"

elseif [DS_PLANO] = "SMCRPMASS20GB" and [TP_SOLICITACAO] = "Alta" then "74,99"

elseif [DS_PLANO] = "SMCRPMASS30GB" and [TP_SOLICITACAO] = "Alta" then "89,99"

elseif [DS_PLANO] = "SMCRPMASS40GB" and [TP_SOLICITACAO] = "Alta" then "114,99"

elseif [DS_PLANO] = "SMCRPMASS60GB" and [TP_SOLICITACAO] = "Alta" then "134,99"

elseif [DS_PLANO] = "SMCRPMASS100GB" and [TP_SOLICITACAO] = "Alta" then "179,99"
elseif [DS_PLANO] = "SMCRPMASS200MB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "19,99"

elseif [DS_PLANO] = "SMCRPMASS1GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "29,99"

elseif [DS_PLANO] = "SMCRPMASS2GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "34,99"

elseif [DS_PLANO] = "SMCRPMASS3GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "39,99"

elseif [DS_PLANO] = "SMCRPMASS6GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "44,99"

elseif [DS_PLANO] = "SMCRPMASS10GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "49,99"

elseif [DS_PLANO] = "SMCRPMASS12GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "54,99"

elseif [DS_PLANO] = "SMCRPMASS15GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "64,99"

elseif [DS_PLANO] = "SMCRPMASS20GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "74,99"

elseif [DS_PLANO] = "SMCRPMASS25GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "84,99"

elseif [DS_PLANO] = "SMCRPMASS30GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "89,99"

elseif [DS_PLANO] = "SMCRPMASS40GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "114,99"

elseif [DS_PLANO] = "SMCRPMASS50GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "124,99"

elseif [DS_PLANO] = "SMCRPMASS60GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "134,99"

elseif [DS_PLANO] = "SMCRPMASS80GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "159,99"

elseif [DS_PLANO] = "SMCRPMASS100GB" and [TP_SOLICITACAO] = "Troca_sem_aparelho" then "179,99"

else '0' endif

Como você está referenciando um campo (update, nao precisa incluir ele no THEN

Abraços

Ranyaky-Vilela

@Nilton_Alves o motivo é porque você colocou then [campo] = "valor".

Se você remover o [campo] = vai dar certo.

A formula fica da seguinte forma: