if you can get to project time then you should be ...
# suiteanalyticsc
creece
08/19/2019, 4:49 PMif you can get to project time then you should be able to use an SQL formula to sum it up and make a custom label
n
NS.TX
08/19/2019, 4:56 PM@creece This was my failed attempt: case when SUM({time.durationdecimal}) =< '40' then ({time.durationdecimal}*{time.laborcost}) end
any guidance on where the formula broke down, or on a better approach?
c
creece
08/19/2019, 4:57 PMim def not a formula master.. is the '40' correct? should it be 40 as a number? that is definitely the approach i would take with the case statements though
n
NS.TX
08/19/2019, 5:34 PMit should definitely be 40.. it appears NS doesn't like sum(...) inside a case statement
NS.TX
08/19/2019, 5:35 PMAre you aware of a function to total a value, since sum isnt accepted?
c
creece
08/19/2019, 6:01 PMif it becomes a pain, I typically like to just add a field to the record that does the work for me so my searches are short and simple (if possible)
creece
08/19/2019, 6:01 PMyou could add a field that non-stores the value and just pull it into your search
n
NS.TX
08/19/2019, 6:43 PMcan you pull a non stored value into a search? I thought that was a limitation
c
creece
08/19/2019, 6:45 PMYou should be able to. You can't pull in a joined non-stored field
creece
08/19/2019, 6:46 PMif it doesn't change it doesn' thave to be non-stored
n
NS.TX
08/20/2019, 11:55 PM@creece ty for your help yesterday - i haven't finished yet, but i've made progress. Always helps getting another's perspective.