Hello,

Can anyone suggest how to insert Excel cell reference in TM1RPTQRYRNG ?

We are trying to replicate Perspective Active Form based report in Pafe. MDX in case of Perspective has derived values that refers to Excel Cell reference. 

Eg:(note - this is not the whole MDX) =TM1RPTROW($B$9,"SOP:D.Customer","Sub.Sold.To.Only.Caption","","","",("{TM1FILTERBYLEVEL( {TM1SUBSETALL( [D.Customer] )}, "&(IF((ForecastInput!B5="Yes"),0,1)&",1)} , [IN.FC.Method].([F.Method.Selection.Value].[Forecast_Method] )= 'Manual FC')} }")),"",0)  

Excel cell reference works by inserting it between  "& Excel Cell Reference &".

However, the syntax for "& Excel Cell Reference &" in case of Dynamic report and  TM1RPTQRYRNG does not work (it does work in dynamic report and TM1RPTROW). 

Thanks,

Rohit,

We are not able to evaluate the formula (IF((ForecastInput!B5="Yes"),0,1)&",1) inside the TM1RPTROW formula's argument. It should be in its own cell somewhere and referenced. Please try the IF statement in a separate cell.