Simple Calculation

Comments

• AlexTZ

  February 2012 edited 1:57AM

  Hello,
  
  You forgot to enclose whole expression in the brackets:
  [[Report_printInvoices.SalePrice] / 1.2]
• Farhan

  January 2018 edited 1:57AM

  I'm having similar issue try to write the similar expression but give me the error
  

  [
  [qryCompletedVisits.Jan]/[[qryTotalVisitsAssigned.Jan]-[qryCancelledVisits_testing.Jan]]
  ]
  
  Also tried like this 
  [[qryCompletedVisits.Jan]/[[qryTotalVisitsAssigned.Jan]-[qryCancelledVisits_testing.Jan]]]
  

  
  Error

  wrote:

  Cell123: Error BC30023: Bracketed identifier is missing closing ']'
  Function: Error 40005: function 'ToString' shadows an overrideable method in the base class 'Object'. To override the base method must be declare 'override....'

  Thanks for your help in advance
• Farhan

  January 2018 edited January 2018

  Farhan wrote: »

  I'm having similar issue try to write the similar expression but give me the error
  

  [
  [qryCompletedVisits.Jan]/[[qryTotalVisitsAssigned.Jan]-[qryCancelledVisits_testing.Jan]]
  ]
  
  Also tried like this 
  [[qryCompletedVisits.Jan]/[[qryTotalVisitsAssigned.Jan]-[qryCancelledVisits_testing.Jan]]]
  

  
  Error

  show previous quotes

  Farhan wrote: »

  Cell123: Error BC30023: Bracketed identifier is missing closing ']'
  Function: Error 40005: function 'ToString' shadows an overrideable method in the base class 'Object'. To override the base method must be declare 'override....'

  Thanks for your help in advance

  
  Resolved after playing with that use curly brackets

  [[qryCompletedVisits.Jan]/([qryTotalVisitsAssigned.Jan]-[qryCancelledVisits_testing.Jan])]
  

  
  after use the above calculation as aim to see the %Achieve simply change the format of the field to to % with two decimal points and display as expected
  Thanks
  Thanks
• ipong

  January 2018 edited 1:57AM

  for complex calculation, use script as custom function
  

  namespace FastReport
  {
    public class ReportScript
    {
      public double CustomFunction(double a, double b, double c)
      {                 
          return a / (b - c);
      }
    }
  }
  

  
  in your textobject:

  [CustomFunction([qryCompletedVisits.Jan],[qryTotalVisitsAssigned.Jan],[qryCancelledVisits_testing.Jan])]