I have a table with sales by month. My Budget is in Dollar I need to convert in Pesos. So I have a variable that take the dollar. The problem is with my formula Divide by all months And produce a distorsion in the final information. For Example. Dollar in January is 772.000 If I do clic in January the information is fine because just take the avg of January. But if I selecte Jan and Feb. January takes another mount, This is because is divide for the avg January and February. I Would Like to see the same information in both cases. The field is called valor_dolar. The Variable (Is the first variable in the list)
