group by month, quarter, year

beesakayawong
beesakayawong Member Posts: 3
edited 2010-12-13 in Navision Attain
Dear All,

I'm new for NAV. and my project is to group field "amount" in "Purch. Inv. Header" classify by field "currency code" group by year, quarter, and month. pls help me
Thank you very much.

Comments

  • Shedman
    Shedman Member Posts: 194
    Check out the DATE2DMY and DATE2DWY functions.
  • beesakayawong
    beesakayawong Member Posts: 3
    I used function DATE2DMY to seperate year,month, but I can't group it. :cry:

Categories