Forum Discussion
roundup
Hi,
For each row i have a column dat I want to roundup
ROUNDUP[QTY];0)
ID | Vendor | Qty | Roundup 1 | A | 0,3 | 1 2 | B | 1,6 | 2 3 | A | 1,2 | 2
Now i want the the sum of the roundup column for each Vendor. At this moment the the table calculates first the sum of the QTY and after that its ROUNDUP
For Vendor A => 0,3 + 1,2 = 1,5 (roundup 2,0)
For Vendor B => 1,6 = (roundup 2,0)
Total roundup = 4,0
The total isn't correct at this moment, the answer must be "8"
Hey,
you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum
CALCULATE(
SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)Hope this helps
2 Replies
Hey,
you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum
CALCULATE(
SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)Hope this helps