Rounding up & calculating on object

ranibosch — Tue, 29 May 2018 12:44:45 GMT

hi,

i have the following object with calculated fields, i would like to add the calculations marked in yellow.

would it be possible to to calculate yellow field?

My column F (number of pallets) calculations is as follows:

(if(IsNull

(sum ([Annual Sales])*-1/12 * (1 + ((sum([3 Months Sales]) - sum([Prior Year 3 Months Sales]))

sum([Prior Year 3 Months Sales])))

[FG Case weight])

(sum([3 Months Sales])*-1/3) / [FG Case weight]

(sum ([Annual Sales])*-1/12 * (1 + ((sum([3 Months Sales]) - sum([Prior Year 3 Months Sales]))

sum([Prior Year 3 Months Sales])))

[FG Case weight]) ) )

[FG Pallet Size]

Re: Rounding up & calculating on object

sunny_talwar — Tue, 29 May 2018 12:46:22 GMT

Should be just using Ceil() function

Ceil(

(if(IsNull

(sum ([Annual Sales])*-1/12 * (1 + ((sum([3 Months Sales]) - sum([Prior Year 3 Months Sales]))

sum([Prior Year 3 Months Sales])))

[FG Case weight]),

(sum([3 Months Sales])*-1/3) / [FG Case weight],

(sum ([Annual Sales])*-1/12 * (1 + ((sum([3 Months Sales]) - sum([Prior Year 3 Months Sales]))

sum([Prior Year 3 Months Sales])))

[FG Case weight]) ) )

[FG Pallet Size]

)