Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Cues limited to Integer and Count?
Pevans
Member Posts: 18
Hiya.
So I notice all the flowfields in the different Cue tables are all of type Integer, and they all use Count (No Sums).
I also notice that my new flowfield of type Decimal with Sum always shows as 0 in the RTC, even though it has a different value in the table.
Are cues limited to Integers and Count?
Any workarounds?
(I haven't found documentation for Cues anywhere, so if there is a Cue Intro for dummies somewhere that I have missed, I apologize!)
So I notice all the flowfields in the different Cue tables are all of type Integer, and they all use Count (No Sums).
I also notice that my new flowfield of type Decimal with Sum always shows as 0 in the RTC, even though it has a different value in the table.
Are cues limited to Integers and Count?
Any workarounds?
(I haven't found documentation for Cues anywhere, so if there is a Cue Intro for dummies somewhere that I have missed, I apologize!)
0
Answers
If you do not care to much about rounding issues you can create a sum on a decimal and convert it to an integer for the cue.
/Brummelhug!
Just one thing about it. You have to be careful about the integer you return with your function. If it is negative, the RTC just shows an error and is closed.