Exam AD0-E902 Topic 1 Question 39 Discussion

* Understanding the Requirement:
* The project name in Workfront must include:
* Purchase Order Number (PO#).
* Name of the product.
* PO Fulfillment Date (formatted as YY/MM/DD).
* If a discount is provided, append the discount percentage and the approver's last name in the format: 15% Discount - UserLast.
* Example Output:
sql
Copy
2837 - Compendium-Premium Running Shoes - 21/02/16 - 15% Discount - UserLast
* Why Option A is Correct:
* The expression in Option A achieves the desired result step-by-step:
* 3.PO#: Includes the PO number.
* 3.Name: Appends the name of the product.
* formatDate(3.PO Fulfillment Date, YY/MM/DD): Formats the PO Fulfillment Date in the desired YY/MM/DD format.
* if(3.Discount Provided? = "Yes"; "- " + 3.Discount % + " Discount - " + 3.Approver Last Name):
* Uses the if function to check if a discount was provided.
* If "Yes," it appends the discount percentage (3.Discount %) and approver's last name (3.Approver Last Name) with the required format.
* Why the Other Options are Incorrect:
* Option B:
* The expression is incorrect because it places if(3.Discount Provided?...) directly after PO Fulfillment Date without using formatDate for date formatting. This results in an unformatted date.
* Option C:
* Uses parseDate instead of formatDate, which is incorrect in this context. parseDate is used to interpret strings as dates, not to format dates for output.
* Option D:
* The expression does not include any conditional logic for checking if a discount is provided. It simply appends Discount - Approver Last Name regardless of whether a discount was given.
* Steps to Use the Expression in Workfront Fusion:
* Place the expression in the module that defines the project title in Workfront.
* Map the fields (PO#, Name, PO Fulfillment Date, etc.) to the respective columns from the CSV data.
* Test the scenario to ensure the output matches the desired format.
* Final Expression (Option A):
3.PO# + " - " + 3.Name + " - " + formatDate(3.PO Fulfillment Date; YY/MM/DD) + if(3.Discount Provided?
= "Yes"; " - " + 3.Discount % + " Discount - " + 3.Approver Last Name)
References and Supporting Documentation:
* Adobe Workfront Fusion Functions Documentation
* Workfront Community: Handling Conditional Logic and Date Formatting