Dear collegues,
When I create a simple table combining different sales measures and comparing 2023 results with 2024, sometimes for one month and year the value is BLANK (becuase there were not revenues).
But in thsese cases the totals are not reflecting the reality (and specially the differences).
When there is a BLANK in 2023 and a value of “1000” for 2024 there is no value in the DIFFERENCE column. How could I convert this BLANK to “0” so that the difference would be showing up as “+1000”???
Could anyone give me any tip or solution to that?? I am going crazy to find a solution and summarize correctly!!
THANK YOU SO MUCH,
Kind Regards.
Alex Cuadros
