Forum Discussion
adavid999
Helper V
Helper Vsimple 0 if blank
Hello I am doing a simple % calculation and would like to replace blanks with zero when blank is returned. The calculation is =[2020 total positive] / [total 2020] * 100 The [2020 total pos...
adavid999 , try like
divide([2020 total positive] , [total 2020],0)
You do not need *100, you can mark it as % column in format session.
You can add +0, but that will create a left join. All data will be displayed
amitchandak
Super User
Super Useradavid999 , try like
divide([2020 total positive] , [total 2020],0)
You do not need *100, you can mark it as % column in format session.
You can add +0, but that will create a left join. All data will be displayed