Calculated Column

[Anonymous]

Hi All,

I could use some help creating a calculated column. 

I would need the following : 

I would like to add a column that devides the total number of leads generated by sales. 
This way I would know that 1 lead lead to for example 0.25 sales. 

anyone knows how I could caluclate that ? 

Robin

[Anonymous]

Nevermind! for some reason, the decimals were set to 0 when switching between the 2 options...

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

column  = 

1/ countx(filter(Table, [salesid] =earlier([salesid]), [salesid])

[Anonymous]

Hi Amit,

That seemd the good way forard! thanks! 
I got the result i wanted, but I still have a question about strange behaviour i cannot explain.

The above column returns this result : 

And that is the way it should! so thats good. But when i change BLANK() to 0 , I get the following result : 

  

Why is this?? 
Robin