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.
Solved! Go to Solution.
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,
Hi Pedro,
Do you know how i can add Euro Currency to the output?
Regards,
Karl.
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)
Thanks Pedro - That worked.
Thank you so much
Regards,
Karl.