Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need some advice with a problem I am trying to solve. My chart expression shows value only if the Dimension field in available on the sheet.
without dimension
Without Dimension week2 expression value in null.
with dimension
Expression:
=if(ValueList(CUM_WK2)=CUM_WK2 and CUM_WK2<>-1,
Count(DISTINCT (if(U18_DT>CUM_WK2, PEOPLE_ID))))
Appreciate your help.
Thanks
Saif
@saifuddin wrote:Hi All,
I need some advice with a problem I am trying to solve. My chart expression shows value only if the Dimension field in available on the sheet.
without dimension
Without Dimension week2 expression value in null.
with dimension
Expression:
=if(ValueList(CUM_WK2)=CUM_WK2 and CUM_WK2<>-1,
Count(DISTINCT (if(U18_DT>CUM_WK2, PEOPLE_ID))))
Appreciate your help.
Thanks
Saif