Add a Pivot Summary into a Email & changing values into Euro

[Karl_Spratt]

Hi Community,

I have to send out a email to a Dist List, I gotten this to work, now i need to make changes.

I need to add a Add a Pivot Summary view into the Email and  show the Sales Order Values & Shipped Lines values in Euro (2 Decimal places) in both the excel attachment, and the Summary in the email.

Can anyone please help here 

Attaching "copies" of the Raw Data files, the WF, and the email I get.

I'd like to add the below into the email along with the current text I have. 

Order Wave	Sum of Sales Order Lines Shipped	Sum of Total Sales Order Lines	Sum of Ext Shipment Value	Sum of Ext Order Value
W1	200	299	€                              5,712,225	€                               15,417,501
W2	15	180	€                                    43,215	€                                  1,549,096
W3	0	219	€                                            -	€                               25,427,873
Grand Total	215	698	€                              5,755,440	€                               42,394,471

TIA 

Karl. 

[pedrodrfaria]

Hi @Karl_Spratt 

I attached your workflow with the portion you were trying to add.

You just have to turn that into a table, and with the layout transform the text and the table into a single object.

Thanks,

[Karl_Spratt]

Hi Pedro,

Do you know how i can add Euro Currency to the output? 

Regards,

Karl. 

[pedrodrfaria · Accepted solution]

Are you talking about the Euro Symbol? You can add to the text and transform it into a string value using the formula.

'€ ' + ToString([Sum_Sum_Ext Shipment Value],2,2)

[Karl_Spratt]

Thanks Pedro - That worked.

Thank you so much

Regards,

Karl.