There's often a requirement to store numbers or dates as analysis fields, but currently we can only store values as text, which leads to the risk of invalid data for the field's purpose being entered. It would be useful if each analysis field could be set to use date, date/time, integer, decimal or text so that the fields can actually be relied upon for calculations etc.
Idea Benefit | Being able to actually use analysis fields to store meaningful information, which is often date or number formatted |
How do you solve for this problem today? | Accept that field contents have to be extracted and converted for reporting purposes and that there's a risk that users will key in non relevant data |
Product Variant | Sage 200 Professional |