show column if

[TomBond77]

Hi friends

In the following sample we can see two KPIs, one for the current year and the other for the previous year.

In 2025 "Depreciation" is null. 

If I select as Year 2025 I only see the rows for "NetSales" and "Costs", the row "Depreciation" disappears. I would expect to show the value 15 for the previous year.

What must I do to get this row displayed as it is in the excel sample? 

Many thanks for your help!

[Or]

It would be quite helpful if you included your expressions...

[TomBond77]

if(Structure='EBIT in % of Net Sales',

num(

Sum({<Calendar.MonthNum={'$(=max(Calendar.MonthNum))'}, Structure={'EBIT'}>} total $(='Fact.AMOUNT_'&$(v_GCLC)&'_MTD_AC'))

/

Sum({<Calendar.MonthNum={'$(=max(Calendar.MonthNum))'}, Structure={'Net Sales'}>} total $(='Fact.AMOUNT_'&$(v_GCLC)&'_MTD_AC'))

,'0.0%')

,

If 

( IsNull(Structure)= -1,null(), 

//Calc 2 + 3 

If (Calculation = '2' or Calculation = '3', 

  num(

    (Sum({<[%Group]={"=[%Group]=[Group_Dividend]"},Group_Dividend={"=[Group_Dividend]=[Group_Dividend]"}, Calendar.MonthNum={'$(=max(Calendar.MonthNum))'}>}$(='Fact.AMOUNT_'&$(v_GCLC)&'_MTD_AC')) )   

    /

        if(Calculation = '2',

    //Calc 2

            (Sum({<[%PI_Key]={"=[%PI_Key]=[Group_Divisor]"},Group_Divisor={"=[Group_Divisor]=[Group_Divisor]"}, Calendar.MonthNum={'$(=max(Calendar.MonthNum))'}>}$(='Fact.AMOUNT_'&$(v_GCLC)&'_MTD_AC')) / 100) 

            ,

            //Calc 3

            (Sum({<[%PI_Key]={"=[%PI_Key]=[Group_Divisor]"},Group_Divisor={"=[Group_Divisor]=[Group_Divisor]"},Calendar.Month=, Calendar.Quarter=, Calendar.MonthNum={'$(=max(Calendar.MonthNum))'}>}$(='Fact.AMOUNT_'&$(v_GCLC)&'_YTD_AC')) *1000) 

        )

      ,'#’##0.0')

    ,

    // Calculation non or 1

        num(

    if(Format_Num = 1, Sum($(='Fact.AMOUNT_'&$(v_GCLC)&'_MTD_AC')),

        Sum({<Calendar.MonthNum={'$(=max(Calendar.MonthNum))'}>}$(='Fact.AMOUNT_'&$(v_GCLC)&'_MTD_AC'))  / $(v_Factor)

    )

        ,'#’##0.0')

)

)

)

[TomBond77]

any ideas?

[fe-c]

Hi, 

I'm not sure if I understand your problem correctly:

Why should the "15" from 2024 should be displayed, when you select 2025?

If you don't want to disappear "Deprecation" maybe you should check your options for handlig "null" or work with alt() or coalesce().