Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have data which has some null values. I have created a table box and I can view these records. As you can see within the table they are displayed as a dash "-"
What I would like to do is create a straight table which groups on some fields apart from the value because I would like to sum each order on value with an Expression. My problem when I do this though is that the records where there are NULL values are omitted from the table. I assume this is because the value cannot be summed? Problem is I would still like to show these records.
I have tried the following expression.
=IF(ticket_replacement_order_no <> 'NULL',sum(orders_val),orders_val = '0')
I am thinking if the field "ticket_replacement_order_no" is not null then sum the order value. Else set the order value to zero
Is what I would like to do even possible?!
Hopefully I have explained this ok!
Thanks v much
In a straight table you can only see demensions where there is a value in one of the expressions for it so what I do is add an expression with the value 1 and then Hide it.
In a straight table you can only see demensions where there is a value in one of the expressions for it so what I do is add an expression with the value 1 and then Hide it.
OMG. That has worked ! I see I was massively over complicating this as this answer was simple...
Thank you very much Carly