Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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]
)
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]
)