Divide one column value between onther column

[Rigolleto]

Hi Forum,

I have a qry, as the image shown, two columns A and B, I need to take every single value from column B and divide by A, no sure about a calculated column, it has being calculated one row a the time so, only the first record has being calculaned, 

Any help will be appreciate 

Thanks

[v-joesh-msft]

Hi @Rigolleto ,

I am not sure what the result you want. If you use the function DIVIDE for calculation, it will return BLANK() on division by 0, If you use the operator "/", it will return infinity.

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EZ14sm34Z11Lkpgpn_...

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.