Topic Options
#40017 - 01/24/14 07:01 AM GridView IncludeAmount function
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
GV Version 9.1A (130402)

I am creating a View from the Sales Analysis data.

The following formula works properly (as I would expect):
INCLUDEAMOUNT( {Amt}, {Date}, "Y", "F" )

However, when I copy and modify the formula as displayed, to pick up values for the previous year, I receive an “Evaluation Failed” error message.
INCLUDEAMOUNT( {Amt}, {Date}, "LY", "F" )

When the formula is written with a “C” (Calendar Year) instead of “F” (Fiscal Year), no errors.

What’s going on?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#40018 - 01/24/14 07:14 AM Re: GridView IncludeAmount function [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Does the fiscal calendar in the GL have a "Last Year"?
_________________________
Andrew Bates

Top
#40019 - 01/24/14 07:21 AM Re: GridView IncludeAmount function [Re: Retired_Guy]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
Yes.
And I am able to duplicate this using both "real" data, as well as sample data.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#40021 - 01/24/14 07:33 AM Re: GridView IncludeAmount function [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Use "{1}Y" instead if you want YTD LY. If you want the whole of the last fiscal year, then the formula gets a little more complicated. This has already been fixed for the next Upgrade to GridView.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Softrak Support), 123 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70648 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30