Помощ за PANTHEON™

 Категории
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Упътства за PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Collapse]Personnel
     [Expand]Employment
     [Expand]Time Terminal
     [Expand]Leave
     [Expand]Daily Allowances and Mileage Rates
     [Collapse]Payroll
      [Expand]Average Salaries
      [Expand]Contributions
      [Expand]Salary Grades
       Income Sources
      [Expand]Income and Payroll Tax Rates
      [Expand]Payment Order Codes
      [Expand]Work Types
      [Collapse]Earnings Types
        Earning Types by Department
       [Expand]Taskbar
        Transfer Registers – Earnings Types
        Edit several earnings types with related criteria
        Formulas for Predefined Earnings Types
        Predefined Earnings Types
       [Collapse]Formula Builder
         Program Parameters
         Average Salaries
         Administration panel
         Payroll Preparation
         Variables for Contributions
         Single Employee
         Employment Record
         Position
         Grade
         Periodic Rating
         Factor Net
         Cost Centers
         GE Variables
         Subjects
         Rounding
         Finished Work Analysis
         Fixed Assets
         Date variables
         Using SQL Statement in Formula
       Additional General Relief
     [Expand]Health and Safety at Work
      Work Processes
     [Expand]Messages in Personnel Settings
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Expand]Program
    [Expand]Documentation
    [Expand]Logon
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Помощ
   [Expand]Messages and Warnings
   [Expand]Additional programs
  [Expand]Ръководство за PANTHEON Търговия
  [Expand]Ръководство за PANTHEON Vet
  [Expand]Ръководство за PANTHEON Фермерство
 [Collapse]PANTHEON потребителски ръководства
  [Expand]Ръководство за потребителя за PANTHEON
  [Expand]Ръководство за потребителя за PANTHEON Retail
  [Expand]Ръководство за потребителя за PANTHEON Vet
  [Expand]Ръководство за потребителя за PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]PANTHEON Web Guides
  [Expand]Ръководство за PANTHEON Web Light
  [Expand]Ръководство за PANTHEON Web Terminal
  [Expand]Ръководство за PANTHEON Web Legal
 [Collapse]PANTHEON Web User Manuals
  [Expand]Започване на PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]Ръководство за потребителя за PANTHEON Web Terminal
  [Expand]Ръководство за потребителя за PANTHEON Web Legal
[Collapse]PANTHEON Гранула
 [Collapse]Ръководство за PANTHEON Гранули
  [Expand]Гранула за служители
  [Expand]Пътнически нареждания Гранула
  [Expand]Гранула за документи и задачи
  [Expand]Гранула Табло
  [Expand]Гранула за B2B поръчки
  [Expand]Гранула за обслужване на клиенти
  [Expand]Гранула за опис на дълготрайни активи
  [Expand]Гранула за складови наличности
 [Collapse]PANTHEON Granules
  [Expand]Започване
  [Expand]PANTHEON Granule Work records
  [Expand]PANTHEON Granule Travel orders
  [Expand]PANTHEON Granule Documents and Tasks
  [Expand]PANTHEON Granule B2B orders
  [Expand]PANTHEON Granule Dashboard
  [Expand]Полеви сервизен гранул
  [Expand]Инвентаризация на дълготрайни активи
  [Expand]Инвентаризация на склада Гранула
[Expand]Потребителски сайт

Load Time: 1812,529 ms
"
   9151 | 9699 | 403145 | Localized
Label

Using SQL Statement in Formula

Using SQL expression in Formula

010381.gif010411.gif010382.gif010383.gif

Use an SQL expression to create a formula. See below on how to do this:

  • an SQL expression begins and ends with a delimiter ~S~
  • a formula can contain any number of SQL expressions
  • an SQL expression cannot contain logical conditions ([..:..]..)
  • an SQL expression cannot contain temp tables with with #
  • an SQL expression can contain variables (# ... #)
  • Logical conditions can contain SQL expressions.

 

You can use any mathematical function available in your version of SQL Server when creating an SQL expression. For example:

  • SIN( float_expression )
    Returns the trigonometric sine of the given angle (in radians) in an approximate numeric (float) expression,

  • COS ( float_expression )
    A mathematic function that returns the trigonometric cosine of the given angle (in radians) in the given expression,

  • TAN ( float_expression )
    Returns the tangent of the input expression,

  • SQRT ( float_expression )
    Returns the square root of the given expression,

  • For all other mathematical functions visit: https://msdn.microsoft.com/en-us/library/ms174077.aspx.

 


 

Formula including a condition such as for example: [#KOLICINA#>20:#Cena#*0,9] [#KOLICINA#>10:#Cena#*0,95] #Cena#

can be created using the following SQL expression:

~S~
case
  when #KOLICINA# > 20 then #Cena# * 0.9
  when #KOLICINA# > 10 then #Cena# * 0,95
  else #Cena#
end
~S~

or


~S~ dbo.MojaFunkcija(#KOLICINA#, #Cena#) ~S~

In this case it is required that you have a customized function dbo.MojaFunkcija().

 

79176.gif For more information on how to create a commute formula using an SQL expression see:Create Formula Using an SQL Expression
000001.gif You can test formulas which do not include SQL expression in the Test panel, since SQL expressions cannot be tested in formula builder.
 

 

 

 

 

Оценете темата
Темата беше ли ви полезна?
Коментар
Вашият коментар ще бъде видим и във форума!