Calculated formula does not work correctly

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sandra6012
    Member
    • Jul 2018
    • 33

    #1

    Calculated formula does not work correctly

    The formula does not apply filters

    saldoDeLaPropiedad=entity\sumRelated('estadoDeCuen taYPagos','pagoTotalARealizarConverted',
    'Pago Atrasado');
  • yuri
    EspoCRM product developer
    • Mar 2014
    • 9216

    #2
    Filter name should be in camelCase, w/o white spaces, and start with a lower case letter.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • sandra6012
      Member
      • Jul 2018
      • 33

      #3
      saldoDeLaPropiedad=entity\sumRelated('estadoDeCuen taYPagos','pagoTotalARealizarConverted',
      'pagoAtrasado');

      this way it doesn't work either

      Comment

      • Maximus
        Senior Member
        • Nov 2018
        • 2731

        #4
        'pagoAtrasado' is a custom filter. I think you need to develop it via code as it explained here https://forum.espocrm.com/forum/deve...6640#post56640, or you can create a report filter and use it in Formula:
        1. https://github.com/espocrm/documenta...report-filters.
        2. https://github.com/espocrm/documenta...mula.md#filter.

        Comment

        Working...