FILTER error

Hi,

  I want to get Account Code "71000"~"72500" of "Net Change" from Navision GLEntry by filter function, I pull all GLEntry data into PowerPivot and I created a "Calculate Field" for PowerPivot in Pivot Table, The Formula is this.

=SUMX(FILTER(GLEntry, GLEntry.[AcctNo]>= "71000" && GLEntry.[AcctNo] <= "72500" && GLEntry.[Department] = "01"), GLEntry.[Net Change])

But when I deep drill the data from this "Calculate Field", the Account Code" start from 51000. does anybody can help what wrong in my formula ?

August 26th, 2015 12:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics