0

Group Sum Cost by Week

Fred

Need to sum cost for the group of week on the EV_Management table

I try this formula but don't work   

let Wk := Week;
sum((select EV_Management)[Week = Wk].'ACTUAL_COST-Act')

 

Copy

 

And not  work too 

let Wk := Week;
sum((select COST_W)[Week = Wk].'Cost')

 

Copy

6 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    To troubleshoot, first you need to make sure that it is finding the correct records. So put this in a new formula field: 

    concat((select EV_Management)[Week = Wk])

    This will return the record Ids of all records that match your filter. Double check this with the actual table.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred 

      The Formulat give me       Error: Field not Found Wk 

      • Fred
      • 1 yr ago
      • Reported - view

      oops, for got the let statement. my bad.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    let Wk := Week;
    concat((select COST_W)[Week = Wk])

    My ID's in COST_W Begin on 9 and finish on 147

    The Formula result Begin 101 and finish on 147

    😯

    I have 135 Registers 

    • Fred
    • 1 yr ago
    • Reported - view

    So is that what you expect?

    By copy your DB does not have a field called Week in the COST_W table.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    Fred

    I close the DB and open it and work, sometimes things happend 

    Yes Fred I have a Week field on the COST_W Table 

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 6Replies
  • 100Views
  • 2 Following