Column Formula: Grand Total / a different Grand Total

Question

HI

I have to create a column formula  where  Grand Total of successes is divided by Grand total (success+failures )

successes and failures are defined by statements

what i do is sum(sum(statement - when failure)/sum(sum(statement - when it is failure and success))

however the analysis gives me 0 for every single raw, so i can not proceed forward in my task.

Do you know what i am doing wrong?

The numerator and denominator are ok as single values in separate columns but when i bring them

together, no values appears.

Thanks

Jose Casquero · Answer

Hi all

i just forgot to cast as double the numerator and do the same for the denominator

cast (         as double)/ cast (     as double)

now it is fixed