Hello,
I have set this schedule column layout, but strangely enough I do not get correct figure for column 1Qtr. Instead of the sum of 1 quarter it displays the sum for the whole year. I set date filter as 15.01.01-15.01.31. What I am doing wrong here?
6175._scr.docx (32.9 KB)
Hi Giedrius, is this 15.01.01-15.01.31 format read as yy.mm.dd? It doesnt seems to me it is for 1 quarter ie. 3 months
You have TWO lines with “Column No” = 080
in general it’s allowed (e.g. to ease up summing lines), but in your case it may cause problems.
One more issue - if you use formulas with numbers, it’s better to avoid numeric-only Column No’s, add some letter(s), otherwise Navision formula parser can go nuts:
your formula: (10/20-1)*100
is there 10 a number TEN or line with Column No = 10 ? The parser is rather smart, it tries it’s best, but can misinterpret such formulae
Yes, I see the problem with double 80. However formula (10/20-1)*100 works fine. I believe its fine until I put in there a line with number 100. Are you saying I can use line numbers with letters? Like 10A, 10B for example?
With regards to 15.01.01-15.01.31 - this is the date filter. I expected that I can still get the sum for a quarter by specifying FY[1…3] regardless what date filter I use?
I figured out what was the problem. One has to configure correct accounting periods before using these formulas. I didn’t have those for 2015 defined.
Anyway, thanks for useful hints for the future.