Forum Discussion
Rigolleto
Resolver I
Resolver IDivide one column value between onther column
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
1 Reply
v-joesh-msftSolution Sage
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:
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.