I am building an Export Scenario using data from the Invoices and Memos screen name.
I am mapping the Post Period column from the Invoice Summary Source Object which contains an example value of "082024"
I would like to use the LEFT function to only extract the "08" value for Period.
Can functions be used on the “Field / Action Name” column and if so, what is the syntax for the LEFT function on the Invoice Summary / Post Period field?
I have tried the following, but none have worked. I receive errors from Missing Operand to Invalid Hdr when running my Export Scenario:
=LEFT(FinPeriodID, 2)
=LEFT(>FinPeriodID], 2)
=LEFT(>Post Period], 2)