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:

 

 

 

 

Fruit

Sales 2017

Sales 2018

Variance

 

 

Apples

15

20

5

 

 

Carrots

-

9

- (wrong)

 

 

Melons

12

0

-12

 

 

 

 

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

 

Thanks

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...