Forum Discussion
Currency conversion issue Sumx Issue
Hello community, Need help please, i'm atually working on a report who present for us the sales value by different slicers (country, category, date). what we have as an existing is two files on dri...
Not sure I am following your example formulas. Given your sample data, could you fill in the last 2 columns in this table?
| Country | Date | Sales Amount | Value | Expected_Result | Formula |
| RUSSIA | 1/1/2019 | 28,325,732 | 76.3054545 | ||
| RUSSIA | 2/1/2019 | 10,624,860 | 75.5497 | ||
| RUSSIA | 3/1/2019 | 24,620,460 | 74.9093921 | ||
| RUSSIA | 4/1/2019 | 15,480,003 | |||
| RUSSIA | 5/1/2019 | 3,880,002 | |||
| RUSSIA | 6/1/2019 | 6,480,002 | |||
| RUSSIA | 7/1/2019 | 6,480,002 | |||
| RUSSIA | 8/1/2019 | 10,480,002 | |||
| RUSSIA | 9/1/2019 | 16,880,002 | |||
| RUSSIA | 10/1/2019 | 1,800,002 | |||
| RUSSIA | 11/1/2019 | 1,800,002 | |||
| RUSSIA | 12/1/2019 | 19,306,110 |
jdbuchanan71 The caption was for sales of february