Hi,
I have a question on how to treat Null values within an LOD. In my attached example, I use a Fixed Lod on Date and Card Type. I need to compare a Providers clicks for a Card Type as a % of the total clicks for that Card Type.
In my example, Provider B only has clicks on one day but the total clicks are not coming through for the other days where the Provider has no clicks.
Is there a way around this?
Thanks,
Siobhan
Hi
the null is not in the lod it is in the data - and there are 2 types of nulls - empty cell nulls and no record nulls - each have a different solution see See it your way: FAQ Series - Not all NULLS are created equal (jimdehner2.blogspot.com) - give it a try and if youi still have problems post your twbx here ate least with dummy data that reflects the type of null you have and the calculation you used
If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote.
Also please help use better track your reply by including a mention to the volunteer who provided the answer – mine is @[Jim Dehner]
Thank you.
Jim
