Sum all of the values extracted from AI Builder

[Anonymous]

Hi there,

I have this issue with AI builder:

I want to sum all columns values from an extracted table from AI Builder. This is a currency field that I'm extracting with € sign so, probably AI builder is extracting it as a string. this table is dynamic meaning that it could have like 2 rows or 11 rows or even more. Can anyone help me with this?

Thank you so much for your help!

[JoeF-MSFT · Accepted solution]

Hi @Anonymous - good use case. I was writing the steps to accomplish this, but I realized it's going to be easier if I show them, so here's a video that explains how to accomplish this:

https://youtu.be/7ZMrorApztc

If this is helpful, this might be the start of a career for me as content creator. 😎 Do let us know if something is not clear or have any additional questions.

[Anonymous]

Hi there Joe!!!!

Amazing and so helpful tutorial!!!!! thank you so much!!!

I'm getting an error:

Cannot process template language expressions in action "Compose_3" inputs in row "0" and column "0": "Template language function "replace" expects the first parameter "string" to be a string. The value provided is of type "Object". See https://aka.ms/logicexpressions#replace for usage details.".

I don't know why this is happening because I really did exatcly what it was supposed (I think!)

I'm choosing the AEValueNoVAT AE VAlue to iterate thought and I get the for each with each value in the composer...

Thank you very much for your help!!! 

[JoeF-MSFT]

Hi @Anonymous - happy to hear it's helpful!

Is AE Value the name of your column? If so, then you need to select the output AEValueNoVAT AE Value value (yes, with 2 values 🙂)

[Anonymous]

Joe!!!!! I was able to do it!!!! thank you so much for your help!!!!