Forum Discussion
Measure with sum and fixed value
Hi all, I have issues with two of my current formulas: 1) Co2 from electricity = Electricity (mwh) x market based factor The market factor is based on the country, therefore the value diffe...
Anonymous Not sure I completely understand this. It looks like you have a table visual with the correct numbers in it. Where do those come from? Can you not just use those in your formula? If the second and third columns are columns, just use the same aggregation for those as in the table visual. For example, if they are default Sum aggregation, use SUM([Market based FACTOR]) or if they are Max, use MAX([Market based FACTOR])
Greg_Deckler thanks so much, your advice worked! I needed to use "max" in place of "sum" for the factors and they reamined at a fixed value.