It feels more like workbooks logic, rather than an...
# suiteanalyticst
ThaFunk
08/19/2019, 4:20 PMIt feels more like workbooks logic, rather than anything being wrong.. I dont use formulas, I'd imagine you could use a formula in this case to source the qty correctly?
g
Gregory Jones
08/19/2019, 4:30 PMFormula field - Absolute Value formula
t
ThaFunk
08/19/2019, 4:34 PMAwesome, I dont know what "float" means but workbooks had me change it from int to float.. looks correct.. Would you mind if I ask another n00b question? Its showing my value with .00 2 decimal places, how can I keep it to a whole number so to speak?
I used this based off your suggestion: ABS({transactionlines.quantity})
ThaFunk
08/19/2019, 4:36 PMI will try and figure it out, I think I need to use the FLOOR function, again completely new to formulas, thanks again that helped a lot
g
Gregory Jones
08/19/2019, 4:37 PMno problem. I'm not sure what FLOAT is either. As for the dropping of decimals - maybe Round() would work? I don't use workbooks that much since it doesn't seem to have made things any easier when compared to saved searches.
t
ThaFunk
08/19/2019, 4:38 PMVery true, I find it easier for filtering data since I'm not use to sql expressions, and the users seems to like the UI. Thanks again!