data not match straight table and pivot table

[Anonymous]

i change the expression beacause of change the negative value to zero so i write below script to convert negative value to positive so its again showing mismatch total with same expression. in straight table total showing 440 its correct but in pivot its showing the same 338.15 after change the negative value to zero

if((sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID)))<0,0,

sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID)))

[sushil353]

Hi,

Please explain your scenario a bit more..

it is insufficient information to comment.

HTH

Sushil

[neha_shirsath]

Hi mohammad faizan,

Can you attach some sample data, so that it will be more clear.

Regards,

Neha

[Anonymous]

please guys check the snapshot and tell me where is the problem the total not match in two different table with same no. of records

[neha_shirsath]

Hi Mohammad,

Have you check the both charts expressions?

and also check in excel if both tables values are same or not.

or else please post qvw.

Regards,

Neha

[kaushiknsolanki]

Hi,

     Try this expression.

     Sum(Aggr(Your Expression),Opportunity_ID))

Regards,

Kaushik Solanki

[Anonymous]

hi neha,

both the chart expression is same  only the different view is there means same expression with same data straight table total showing 398.150 and pivot showing 399.150 with same quarter Q1

[sushil353]

hi mohammad,

It is hard to analyze but still try to change the option of TOTAL MODE in expression tab.

Try different option like Expression Total or Sum of rows.

HTH

Sushil

[Anonymous]

thanks kaushik always your soluttion work i know, its work fine.

[Anonymous]

i change the expression beacause of change the negative value to zero so i write below script to convert negative value to positive so its again showing mismatch total with same expression.

if((sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID)))<0,0,

sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID)))