Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Average

Hello, I want to calculate an average of a column after modifying it with a multiplication. This means that I want to calculate the average of: CA N with discount = [CA N]-[Discount 1]-[Discount ...
Need Help
  • LeandroDeodato's avatar
    LeandroDeodato
    2 years ago

    try declare var with this mensure [CA N]-[Discount 1]-[Discount 2] and return average var,

    or change your mensure to a custom column, and use this column in average.

LeandroDeodato's avatar
LeandroDeodato
Resolver II
2 years ago

average(CA N with discount) dont work?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    No, I got the message: AVERAGE function only accepts a column reference as an argument