6 Replies Latest reply: Aug 4, 2016 11:32 AM by ROSANNA LUO RSS

    Chart data not showing up correctly, I used the same expression from pivot table which shows correct data

    ROSANNA LUO

      I used the same expression from pivot table which shows correct data, but the chart data is incorrect.

       

      For example, in Qlikview the weighted total from my pivot is showing $64954,

       

      whereas when I copied/pasted the same expression into chart =num(sum(IF(TODAY()>[Opp Exp Decision Date], ([Local Member Firm Fees]*[Opp Probability]/100)/295*0.5,[Local Member Firm Fees]*[Opp Probability]/100/295)/IF(((([Opp Est Eng End Date]-[Opp Est Eng Start Date])/30)=0),1,([Opp Est Eng End Date]-[Opp Est Eng Start Date])/30)),'#,###.'), the incorrect value 1,332,827 shows up.

      Thanks for your help.