13 Replies Latest reply on Feb 5, 2018 1:59 PM by Deepak Rai

    How to put default value in locked cell while having metrics are categorized using another dimension col?

    Aamir Gudawala

      I am using IFNull function to put default value to the cell which possibly be null. It works until I categorize the metrics based on another dimension col. Attached the screenshot with area highlighted. Upon clicking this area, it does not highlight. Usually, a hand arrow pops up if you hover the field which has value but for the locked cell it stays in mouse pointer. My thought is that it is locking the cells down. "Attribution Engagement" in cols section seems to be culprit but I need that col the way it is and just format the data to "0" if null or empty. Any solution will help. Thanks.