#ERROR IF we use extended merge dimension

[former_member221192]

HI Experts,

if i use extened merge dimension it is showing #errror,find the snap shot ie #error,,

if remove Extended merge dimension #error is removed but #multivalue,

here i have to use Extended merge dimendion if i use Extended merge dimension  most of the cell got chaging #error help me..

[sateesh_kumar1 · Accepted solution]

Hi Ganapathy ,

You are getting #ERROR because the extended merge may be pulling some data into variable you are calculating  that may have some null values /wrong format . find where you are getting the #ERROR in formula.

try =if(iserror([Object]))= then formula...