Problem with JOIN or Crosstable

[Anonymous]

Hi all,

I am experiencing a problem using a join or crosstable. A numeric value is set to -1 automatically where it was about to show another value instead.

Does anyone had the same problem? How can I fix that? I would like to sum all these values instead of '-1' and I am getting the wrong result.

Below is the table

MTX TYPE	US$
Handling	-1
Tyre	-1
Other	-1
Handling	-1

Thank you!

[Anonymous · Accepted solution]

Hi Sunny.

Just tested and it doesn't work.

The solution is below.

if([MTX Date]>=Date(MonthName([TEST Start Date]), 'MM/YYYY') and [MTX Date]<=Date(MonthName([TEST End Date]), 'MM/YYYY'),
if([TEST Type]='STD',

if(Handling='0', Handling, Handling='0')),

[Handling])  as  [Handling],