Jump to content
We've recently updated our Privacy Statement, available here. ×

Cross Table NULL Values

Lukas Egrt

Recommended Posts

Hi guys, I'm currently solving this problem:






Sales 2017

Sales 2018













- (wrong)











Sales = SN(Sum([sales]),0) as [sales]

Variance = Sales 2018 - Sales 2017


Carrots were not sold in 2017, therefore crosstable gives value "-".

Every other operation with carrot is therefore corrupted, if I calculate within its Sales 2017.

The main goal Im trying to achieve is to replace the values of Carrot Sales in 2017 with 0, so the variance is calculated correctly.

Editing the source data is not possible due to its complexity and size.

There are some similar topics in this forum, but without any solution or advice pointing to the mean.

Do you have some idea about some workaround

Thanks a lot!

Link to comment
Share on other sites

Hi @richierich,


thank you for your comment, but it seems that this workaround is not working, as the cross-table does not consider the parameter Carrots in 2017 at all, because its missing in the source.


Is there any other workaround which could be applied here



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...