Forum Discussion

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago

How to create a column with incremented values

Hello, I have a table called WorkersSalary and a field called salary and another field called name. I want to plot another field wich is Salary incremented = salary x 0.8   Name Salary Salar...
CALCULATE
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

 

you cannot use the column directly. Try:
Slary_incremented = SUM('WorkersSalary'[salary]) * 0.8

 

Regards

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago

No, this doesn't work, I don't understand what number returns but it is definitely wrong

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I tried it with your table:

     

    Name

    Salary

    John Smith25000
    Joe Black31000
    Mark Johnson26000

     

     

     

    Make sure that your Data Type of the Salary column is not set to text.

     

    Regards

    • fabiomanniti's avatar
      fabiomanniti
      Helper III
      4 years ago

      It is not set to text but, for what I see it is a Sum.

      I am having the same problem with another data.

      I have a field "rent_days" which is the number of days a machine is rented. I must convert this number into years so I'm doing

      rent_years = sum('Table'[rent_days])/365

      but the output numbers aren't reasonable.

      What I'm seing is the rent_days is grouped as a sum.

      I don't really know how to change it.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hey, 

         

        you can change that in the table view. Select the column with the sum-icon in front and change it above to Do not summarize. See below:

         

         

         

        Mark the post please as solution if this does the trick 🙂 


        Regards