6 Replies Latest reply on Aug 16, 2018 4:00 AM by Gaurav Arora

    Divide SUM if

    Alessandro Passera

      Hi everyone,


      I added up the value of the Orders for different countries by suing SUM and I plotted the results using horizontal bars.


      In my dataset, the majority of the countries use Euro as their currency except for few of them.


      What I would like to do, it's to take the sum of one of these non-Euro countries, for example USA, and divide the sum of the Orders value by let's say 1.14 in order to get the corresponding value in Euro in the horizontal bar.


      The names of the variables are "Order Total" and "Country".


      Is there any possibility to do so?


      Thanks in advance!