CNVUSD formatting

Question

Hi all,

I'm needing to format my data and create a cumulative CVTUSD row for each product. Please see data attached.

Do you know how I may do this?

Thanks so much

Required format LL updated.xlsx

AngelosPachis · Answer

Hi @Hettie2102 ,

One way to go about it is to first create a Multiplier column for each currency and then join it back to your main dataset, before estimating the CNVUSD profits and costs.

Let me know if you have any questions on the workflow. Hope that helps.

Angelos

example.yxmd