Hello,
I am trying to build a flow that updates the amount for a specific period on the basis of dates. Please assist me in designing the flow. Kindly look at the details in the attached sheet.
@Learner09 You only need to make these adjustments:
You can keep following the steps above for any similar field that you need to add. The formula is only really concerned with [USD], [Start Date] and [End Date].
Certainly manageable by Transposing the dataset, doing the necessary data manipulation, and then Cross-Tabbing the dataset back into its original format.
Note that I had to make some modifications to the original dataset in Excel. I aligned all the necessary columns so that their column names are in the same row in Excel:
This is the resulting dataset:
@Peachyco thank you so much for the flow, it working fine, but now I have another requirement I have to update the USD at the customer level for different customers. Could you please modify the flow at the customer level? Please the example file.
