How to Create a Custom Column by using IF Statement

[mudassar]

Hi Guys,
I am new to PowerBI.I have been creating a report which need a Custom Coulumn "RPC" 
So my formula is 
=IF(SoldClicks > 0 , Revenue/SoldClicks,0) 
Please see the attached image;

What i am doing wrong ? 
Thanks

[jthomson · Accepted solution]

I'm guessing that you're using an if to prevent division by zero, just make it as a conditional column giving it the value 0 if it's 0 otherwise give it the value rev, then amend that in the formula bar to rev/soldclicks:

[jthomson · Accepted solution]

I'm guessing that you're using an if to prevent division by zero, just make it as a conditional column giving it the value 0 if it's 0 otherwise give it the value rev, then amend that in the formula bar to rev/soldclicks:

[mudassar]

Thanks for your Prompt Reply.
But in "Conditional Column", it does not allow me to divide two fields.

Thanks

[jthomson · Accepted solution]

No, it doesn't, which is why I indicated to amend it in the formula bar afterwards. Just set it to be one of the two in the conditional column tool and change it once you've got that done.

[mudassar]

Thanks @jthomson
Got Your Point!
Now its Working Fine 🙂