REG-VALUE MIS MATCHING

[#1]

Hi Team,

we have straight table and the dimension and expression for the two tabs are same ,but the values like sales vs Target are not matching.

we have four tabs and in that the first tab and fourth tab we have sales vs Target and same dimension,but the values are not matching .iam writing the expresion aslo here

first tab

sales:

=if(vCalType='value','SalesV','SalesU')

  =if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<CBU={"=len(CBU)>0"}>} SalesUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

Target:

=if(vCalType='value','TargetV','TargetU')

    =if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<CBU={"=len(CBU)>0"}>} TargetUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

second tab

sales

=if(vCalType='value','SalesV','SalesU')

     =if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<BU={"=len(BU)>0"}>} SalesUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

target

=if(vCalType='value','TargetV','TargetU')

if(GetPossibleCount(PackageID)>1 and vCalType='unit',null(),sum({<BU={"=len(BU)>0"}>} TargetUnit*if(vCalType='value',if(Year>=2015,[CIM Price],[Actual Price]),1)))

can any one help me out from this and we have difference only we have given CBU AND BU THESE ARE THE BRANDS

[jagan]

Hi,

Check there is any sheet triggers which are making any selections?

Is Current Selection box values are matching in both the Sheets?

If the expressions and dimensions are same then both the charts should match.

Regards,

Jagan.

[#3]

IN THE SHEET PROPERTIES------->Triggers----> WE HAVE ONE TAB REPORT object id AND ANOTHER WE DONT HAVE

[jagan]

Hi,

If you attach the file or screenshot then it will be easier to give solution.

Regards,

Jagan.