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 ?