I am using the following expression to format an amount where T0_LOOKUP is Like "BRT%" but no data is selected; however if I use = "BRTAC" (for example) data is found. Why is Like not working as expected?
format(cint((Sum ( ([Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.AMOUNT] ) * ([Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.PERIOD]="AYTD") * (trim([Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.T0_LOOKUP]) Like "BRT%") ) Group By( [Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.Lvl_04]))/DenominatorInt),"#,###,##0"" ""; (#,###,##0);-"" """)
format(cint((Sum ( ([Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.AMOUNT] ) * ([Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.PERIOD]="AYTD") * (trim([Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.T0_LOOKUP]) Like "BRT%") ) Group By( [Z_SSH_MA_PnL_CSL_Var_Sum_MainCo_YTD_DataView.Lvl_04]))/DenominatorInt),"#,###,##0"" ""; (#,###,##0);-"" """)