Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tmg_mosburger
Contributor III
Contributor III

Set analysis mit Uhrzeit

Hallo zusammen,

ich komme bei einer Formel mit Uhrzeit nicht weiter.

In einem Inputfeld gebe ich die "Von Uhrzeit" als Parameter vVonZeit ein.

Die Formel sollte nun so aussehen:


sum({<Startzeit = {">=$(#vVonZeit)"} >}WPA_Prod_reported_length*WPA_Prod_paperwidth)/1000

ich hab es auch schon so versucht:

sum({<Startstunde = {">=(hour(#vVonZeit)"} >}WPA_Prod_reported_length*WPA_Prod_paperwidth)/1000

bis jetzt ohne Erfolg.

Hat jemand einen Tip für mich?

lg

Thomas

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

It all comes to the format in which the timestamps are stored into the Startzeit field. Assuming that this field has values with the mask 'hh:mm:ss', for example, 15:30:02 or 08:56:45 then

Sum({< Startzeit = {">=$(=Timestamp(vVonzeit, 'hh:mm:ss'))"} >} WPA_Prod_reported_length * WPA_Prod_paperwidth)

Also, depending on how the variable stores the values you will need further formatting of the timestamp, or none at all.

View solution in original post

4 Replies
Anil_Babu_Samineni

Which Hour you want to check? Hour(PArameter) won't return.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Miguel_Angel_Baeyens

It all comes to the format in which the timestamps are stored into the Startzeit field. Assuming that this field has values with the mask 'hh:mm:ss', for example, 15:30:02 or 08:56:45 then

Sum({< Startzeit = {">=$(=Timestamp(vVonzeit, 'hh:mm:ss'))"} >} WPA_Prod_reported_length * WPA_Prod_paperwidth)

Also, depending on how the variable stores the values you will need further formatting of the timestamp, or none at all.

rubenmarin

maybe?:

sum({<Startstunde = {">=$(=hour(#vVonZeit))"} >}WPA_Prod_reported_length*WPA_Prod_paperwidth)/1000


You can try adding to a table expression without label, hovering the mouse over the expression label you can check how the values are expanded.

tmg_mosburger
Contributor III
Contributor III
Author

Thanks a lot, it has to be something with the format of the formula. = if(Startzeit >= Timestamp(vVonZeit, 'hh:mm'), 'Higher', 'Lower') is working fine, but not the Set analysis.

Von: Miguel Angel Baeyens de Arce

Gesendet: Donnerstag, 15. Februar 2018 15:33

An: Gell, Thomas <TGell@mosburger.at>

Betreff: Re: - Set analysis mit Uhrzeit