0

I Need the sum of 'total Time' for each time I change Client Choice

I Need the sum of 'total Time' for each time I change Client Choice

4 replies

null
    • Fred
    • 2 mths ago
    • Reported - view

    maybe something like:

    sum('View by Choice Client'.'Total Time')
    
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       Hi Fred the 'View by Choice Client' is a table View, no work

      I use this formula on 'View by Choice Cliente'

      
      let cc := 'Client Choice';
      let date := Date;
      select 'Booking Time' where Code = cc and Date = date
    • Fred
    • 2 mths ago
    • Reported - view

    oh, yes forgot about that. Maybe try:

    let cc := 'Client Choice';
    let date := Date;
    sum((select 'Booking Time' where Code = cc and Date = date).'Total Time')
    

    Or you can do it through the dC field:

    let t := this;
    let cc := record(clientchoicetablename,number('Client Choice'));
    sum(cc.'Booking Time'[Date = t.date].'Total Time')
    
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

       Excelent Fred work 👍 Thanks

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 4Replies
  • 30Views
  • 2 Following