CNVUSD formatting

[Hettie2102]

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 

[AngelosPachis]

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