Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Sumar mas de 2 campos con un workflow

Sumar mas de 2 campos con un workflow 5 months 1 week ago #77541

  • melecio55
  • melecio55's Avatar
  • Offline
  • New Member
  • Posts: 12
  • Thank you received: 1
  • Karma: 0
Alguien que me pueda indicar como puedo sumar n cantidad de campos con un workflow, ya que con la formula que viene en el manual solo me suma 2 números. Adjunto como tengo la formula.

{add ({P0}; {P1}; {P2}; {P3}; {P4}; {P5}; {P6}; {P7}; {P8}; {P9}; {P10}; {P11}; {P12}; {P13}; {P14})}
The administrator has disabled public write access.

Sumar mas de 2 campos con un workflow 5 months 1 week ago #77543

  • AlxGr
  • AlxGr's Avatar
  • Offline
  • Elite Member
  • Posts: 246
  • Thank you received: 47
  • Karma: 6
No lo he probado pero ya probaste a poner la funcion en forma anidada:



(add(c;(add(a;b))...
The administrator has disabled public write access.

Sumar mas de 2 campos con un workflow 5 months 1 week ago #77545

  • melecio55
  • melecio55's Avatar
  • Offline
  • New Member
  • Posts: 12
  • Thank you received: 1
  • Karma: 0
Gracias por tus comentarios.

Ya intente con

{(add({P0}; {P1})add({P2};{P3}))}

{add({P0}; {P1})add({P2}; {P3})}

Pero no funciona
The administrator has disabled public write access.

Sumar mas de 2 campos con un workflow 5 months 1 week ago #77548

  • melecio55
  • melecio55's Avatar
  • Offline
  • New Member
  • Posts: 12
  • Thank you received: 1
  • Karma: 0
Listo. Yo tenia mal estructurada la formula, se las comparto por si alguien la llega a necesitar, solo ajustenla de acuerdo a los campos que se necesiten.

{add({add({add({add({add({add({add({add({add({add ({add({add ({add({add ({P0}; {P1})}; {P2})}; {P3})}; {P4})}; {P5})}; {P6})}; {P7})}; {P8})}; {P9})}; {P10})}; {P11})}; {P12})}; {P13})}; {P14})}
The administrator has disabled public write access.

Sumar mas de 2 campos con un workflow 5 months 1 week ago #77555

  • samsaint83
  • samsaint83's Avatar
  • Offline
  • New Member
  • Posts: 1
  • Karma: 0
Under add Workflow Action select New field update.
Select the field you want to update for ex: sales tax
click use formula to set new value, In the formula editor you can use this formula
IF( ISPICKVAL(Item, veg) , 2%, IF( ISPICKVAL(Item, nonveg) , 12%, IF( ISPICKVAL(Item, sweet) , 0, 0) ) )
Click save and New

Then again select field you want to update for ex: service tax
click use formula to set new value, In the formula editor you can use this formula
IF( ISPICKVAL(Item, veg) , 5%, IF( ISPICKVAL(Item, nonveg) , 20%, IF( ISPICKVAL(Item, sweet) , 0, 0) ) )
Click save and New

Then again select field you want to update for ex: other tax
click use formula to set new value, In the formula editor you can use this formula
IF( ISPICKVAL(Item, veg) , 1%, IF( ISPICKVAL(Item, nonveg) , 5%, IF( ISPICKVAL(Item, sweet) , 0, 0) ) )
Click save
This will work for sure!
The administrator has disabled public write access.
Moderators: disytel
Time to create page: 0.043 seconds
Powered by Kunena Forum