Forum Discussion
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 ...
Anonymous
try create a custom column
if [Figure 2] = null then [Figure 1] else ([Figure 1] + [Figure 2])/2
Hi Anonymous
how is your data look like in data source?
and [2,000 + 5,000]/2 is equal 3500, not 4500, I think 🙂
I need to pop the 300,000 and 500,000 over to the Figure_Tidy Column. How could i do it?
Anonymous
so, whats your business logic?
how do you want to calculate Figure_tidy if Figure2 is null?
Anonymous
try create a custom column
if [Figure 2] = null then [Figure 1] else ([Figure 1] + [Figure 2])/2It works! Thank you!