Forum Discussion
qmestu
Helper IV
Helper IVDivide function with missing values
Hi I have the following data: value year category 72175 2011 A 71709 2012 A 70671 2014 A 70369 2015 A 70103 2016 A 69922 2017 A 69828 2018 A 69776 2019 ...
qmestu ,
did you try to enable the show items with no data on the year field ?
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Idrissshatila
Super User
Super UserHello qmestu ,
did you try this C=calculate(divide([b],[a], "No value" ))
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
qmestuHelper IV
Helper IVEven if this would work, it would show "no value" on the chart, which isn't what i need. I need it to show the year but without any value. Thanks.