Forum Discussion

danielboi's avatar
danielboi
Icon for Helper I rankHelper I
4 years ago
Solved

Calculating FX / currency Variation in Sales Report

Hello community,   I want to calulate sales price variations, which is a comparison of budget price, budget volume and actual price, actual volume.   It starts with eliminating currency effects. ...
  • danielboi's avatar
    4 years ago

    OK, managed to solve it on my own. 

     

    Since I am doing the model also in Excel I am cannot use bi-directional filtering. Of course I tried using crossfilter, it did not work. Over night I got the epiphany how to properly use crossfilter. Issue is solved!