Wednesday, June 12, 2019

Enter a Note/SQL Comment within a Formula

Business Use Case:
You can add comments to clarify the purpose or effect of particular SQL statements. Your comments can help you or others to understand the role of the statement within the formula. Note that SQL Comments have no effect in the formula and will not show in the search result.

Format:
Enter your comments at the end part of your formula.
/*Enter your note here*/


Example:

Formula (Currency)
Formula:

Case When {transaction.accounttype} = any('Income', 'Other Income') then {transaction.amount} else 0 end
/*This formula determines all Customers and their Total Sales even if Customer has no Sale for certain time period*/



Note:
1. The Comments will show on Edit Mode of the saved search
2. Use the above Formula SQL on a customer search

No comments:

Post a Comment