Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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],