Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help for Custom Column Formula

I've got a column with mixture of figures (eg 2,000 and 2,000 - 5,000) and i'm suppose to calculate the average of that range (eg [2,000 + 5,000]/2 = 3,500).    I've tried using delimiter to spilt ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    try create a custom column

    if [Figure 2] = null then [Figure 1] else ([Figure 1] + [Figure 2])/2

     

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

so, whats your business logic?

how do you want to calculate Figure_tidy if Figure2 is null?

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

try create a custom column

if [Figure 2] = null then [Figure 1] else ([Figure 1] + [Figure 2])/2

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It works! Thank you!