Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have the above table box, I have it checked on the Presentation to "OMIT when values are Null" For Region Name , NewCoins and then Ive tried different combinations of each if the empty columns.
I still am getting all that empty rows.
Can any advise how I may get rid of them ?
Thanks
Anne
I don't think that is possible in a tablebox (not unless you filter your data in the script)
I would suggest to try a straight table.
Hi Dennis
I wouldnt actually have an Expression for it to be a straight table , do you have any idea of a work around for this ?
Thanks
A
Actually Dennis
I did put a random experssion and it still isnt hiding Nulls , I reckon it need to be amended in Script
Thanks
A
I see what you mean. You are right.
Did you try this for the other tabels aswell?
Hi Dennis
Ive used this Omit values Null before and it has always worked as I have expected.
But These loads are quite different than the way I normally do things, Im going to amend the script to something like
if([Parent Branch]=' ',null(),[Parent Branch]) as Branch
Then hopefully it will recognise the Blanks as NULL so the check in the Chart should work !!
( I hope !!)
Thanks
A