Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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])