For Loop for table

[MichalisGemisto]

Hello everyone,
is there any way to loop the items/certain field of a table (not array)? Also, is there additional info about formula language apart from the user-guide?

Thanks a lot,

------------------------------
Michalis Gemistos
------------------------------

[ewilson]

Hi @MichalisGemisto,

​I assume when you refer to looping a table you're actually talking about looping over a Collection data item? As for the Calculation stage and the possibilities, there are some training labs available on the Digital Exchange that go in to some detail. There's additional training available on Blue Prism Learning Lounge. Do you have any specific questions?

Cheers,
Eric

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[MichalisGemisto]

Hi Eric, thanks for your quick reply.

I have created a table in the DFD for all the products in the product list of an invoice. That table has a number of parametric variables ( using :# you can get their value). So now I want to calculate the overall amount of the products for that invoice by looping on all the products on the product list/table. Thanks for the additional info about the training I will definitely have a look at them. 

------------------------------
Michalis Gemistos
------------------------------

[BenLyons · Accepted solution]

Hi Michalis,

Sounds like you're looking to sum a column of values. E.g. SUM(item_value).

For this you'll need to add a field to the header section of the DFD, then you can use the SUM formula and the column name. 

The online help is all there is right now in terms of formula detail, are there any in particular you'd like to know about?

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

[MichalisGemisto]

Hi @BenLyons,

thanks for the answer, everything seems to be working fine with your suggestions. I would like to know if there can be two expressions inside a formula. I know that you can have nested functions ex. IF(    IF(   statement,   if_true,   if_false),   yes,    no) but in my case having two independent IFs ex.

if(something, do this, do that)

if(something_else, do this 1, do that1)​

is more useful. (I have tested that above example and I know it is not valid, however I am wondering if there is something else that can be done.)

------------------------------
Michalis Gemistos
------------------------------

[BenLyons]

Hi Michalis,

Absolutely, nested formulas are a great way to get the most out of Decipher. Check on the formula help page for everything that's available for use http://bpdocs.blueprism.com/decipher/user-guide/formula-language.htm

And if you need any advice on how to combine them, let me know.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

[MichalisGemisto]

Thanks

------------------------------
Michalis Gemistos
------------------------------