I have a straight table, where, First 3 Column is my Dimension and another 6 is my Expression. Rolling three month calculation and then status and last one is Also some calculation.
Now in Column 7, 8 and 9 there is null or missing value are available. Now I want to remove or hide the same row from my straight table.
Output will be same as it is in excel. only want to remove or hide null or missing value rows from straight table.
can anyone help me on the same.
Please find the attached xls. for the same.
Please response, If it is possible with an example.
Try applying this on dimensions which eliminates null values for Green, Amber and RAG
Workstream: =if(not isnull(Green) or not isnull(Amber) or not isnull(RAG),Workstream) Ref: =if(not isnull(Green) or not isnull(Amber) or not isnull(RAG),Ref) LOB: =if(not isnull(Green) or not isnull(Amber) or not isnull(RAG),LOB)
Hi Bharat, Thanks for response. This is working fine for Green / Amber and RAG Expression, Where the null or missing value. But when the rolling month expression has null or missing value is available that time it is not working. I tried to make the code for the same but it is not performing. Code is below.
Workstream : =If((Not IsNull([Green])or Not IsNull([Amber]) or Not IsNull([RAG]) or Not IsNull($(vCurrentMonthM0)) or Not IsNull($(vCurrentMonthM1))),[Workstream Calc Dim])
KPI : =If((Not IsNull([Green])or Not IsNull([Amber]) or Not IsNull([RAG]) or Not IsNull($(vCurrentMonthM0)) or Not IsNull($(vCurrentMonthM1))),KPI)))
LOB : =If(Not IsNull([Green])or Not IsNull([Amber]) or Not IsNull([RAG] or Not IsNull($(vCurrentMonthM0)) or Not IsNull($(vCurrentMonthM1))),[LOB Calc Dim])
