Hi!
A question - can I suppress zeroes when I'm using a Column chart?
I saw that option in Waterfall.. but I guess it is the only one where I can do it?
And no options about handling Zeroes in other types of charts?
Thank you.
Hello @JoannaAn
Can you show us an xample?
Have you tried setting to zero format to Blank?
Another option is to set a filter to hide items with value 0 from the chart
@JoannaAn
You can try using an IF THEN ELSE statement in you data to return DIVIDE(0,0) if the data is a zero this will return a NA for all zeros which will not show on the final chart.
If you need to display this data in a grid on a page create a duplicate module and use this IF THEN ELSE and use this duplicate grid to feed your chart.
I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, I…
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
