Forum Discussion

Chalklands's avatar
Chalklands
Icon for Helper I rankHelper I
8 years ago
Solved

Trying to add a calculated column into a table

Hello, Sorry if this is a very simple question, but hope somebody can help me.   I'm trying to add a new calculated column in a table to calculate 'Total Cost Of sales'. The formula I have is:   ...
Need Help
  • Chalklands's avatar
    Chalklands
    8 years ago

    Thanks Johanno.

     

    My fault!

    I think the problem is not BI related but the raw data source.....One of the columns has not been populated yet for September, so is appearing as 0. Obviusly anything multiplied by zero = zero!!!!

     

     

    Pete

Johanno's avatar
Johanno
Icon for Continued Contributor rankContinued Contributor
8 years ago

It should work for both when it's in the same table, but I think best practise is to also specify the table names in the formulas and not only the column name e.g. Total=TableName[Quantity_Ordered]*TableName[Standard_Cost_Per_Case] 

Also, I note that you have a " before Quantity if that has something to do with it.

 

Chalklands's avatar
Chalklands
Icon for Helper I rankHelper I
8 years ago

Thanks Johanno.

 

My fault!

I think the problem is not BI related but the raw data source.....One of the columns has not been populated yet for September, so is appearing as 0. Obviusly anything multiplied by zero = zero!!!!

 

 

Pete