In ACL, a conditional computed field (CCF), is basically a regular computed field with some fireworks.
It looks and acts much like a regular computed field, but has some extra parts that do some extra work. Fortunately, the extras are NOT complicated, and after reading this post, you will find that will you use CCFs frequently.
So what’s the difference?
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, add, boot camp, CCF, character, column, computed field, conditional, country, customer, c_, default, expression, format, formula, function, length, manual, region, sales, script, skyyler, start, string, SUBSTR, syntax, text, tip, type, video, what is
To make it easier to read articles on the Internet that span multiple pages, look for a Print button or link on the page.
Most of the time, the link is at the bottom of the page, but sometimes the Print link is at the top (of course, not all web sites offer this, but most of the online magazines do).
Continue reading →
Like this:
Like Loading...
A computed field is a field in an ACL table that you create using expressions.
An ACL expression is similar to a Microsoft Excel formula [e.g., =SUM(A1:A2)] in that it contains at least one function [like SUM]. Excel formulas operate on cells (like A1 and A2), but computed fields operate on fields.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to..., Written by Skyyler
Tagged as acl, character, computed field, customer, expression, format, formula, function, length, region, skyyler, start, string, SUBSTR, syntax, text, tip, type, what is