Navigation:  Module 1 - Energy Accounting > Accounts & Invoices Tab > User Defined Components > Examples >

Examples of more complex formulas

Previous page Next page
  rev. 2011-02-09        
DateRange([StartDate],[EndDate]).InPeriod(ParseDate(04/01/00))
DaysInPeriod([StartDate],[ReadingDate],  04/01/00,  11/30/00, True) * IIF(([Consumption]-170) > 0,  ([Consumption]-170), 0)  * [Summer_Rate1_Level4]
IIF([Power_Factor] >= 0.9, [Demand] * [Class7_Network_Rate], (([Demand] / [Power_Factor]) * 0.9) * [Class7_Network_Rate])

 



snippet_ComplexFormulasExamples         ©2014 Managing Energy Inc.