In desperate need of help with my formula

[Lena_Osorio-Gem]

I am creating a table where our team enters LinkedIn social media analytics. I have only dabbled with formulas, so I went to my friend for help, and he gave me a good formula, but I think it needs tweaking.

Here is my dilemma:

First, I want the “Click-Through Rate” to display “Not Available” for future posts. For current posts (as well as past posts); I would like to display a number, even if it’s zero.

If you notice in my screenshot, there were certain past posts with data entered, but it doesn’t display anything in the Click-Through Rate cells. :woman_shrugging:t5:

Second, I would like to display the Click-Through Rate as a decimal that moves the decimal point. For example, instead of displaying 0.0198, I would like for it to display, 1.98%

Here is the formula:

IF({clicks} > 0, ROUND({Clicks}/{Impressions},2), if({Impressions} >0, ROUND({Clicks}/{Impressions},2), “Not Available”))

I appreciate any and all help.

[Lena_Osorio-Gem]

Note, there will ALWAYS be a number for impressions, but NOT always with clicks. Not sure if that makes a difference or not.

[kuovonne]

What determines if a record is “past”, “current”, or “future”?

It also looks like you are using your original formula in your screen shot. Is there a reason why you have not tried the suggestion put forth in this thread?

[Lena_Osorio-Gem]

Thank you, kuovonne. I have inserted your formula, and it works well. I guess I was also looking for future results to say, “not available”, but if it’s blank, that works for me too.

In answer to your question about what determines past, present, or future, please see below:

Past Click-Through Rate = 0 (if no clicks) or a decimal percentage if there were clicks i.e.: 1.98%

Present Click-Through Rate = same as above

Future Click Through Rate = a blank cell or “Not Yet Available”