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
    • 1 yr ago
    • Reported - view

    maybe something like:

    sum('View by Choice Client'.'Total Time')
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr 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
    • 1 yr 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
      • 1 yr ago
      • Reported - view

       Excelent Fred work 👍 Thanks

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 4Replies
  • 38Views
  • 2 Following