Aggregation in a If statement

tomf122 — Fri, 01 Mar 2024 11:43:46 GMT

I am having trouble when trying to create a measure in a pivot table. It has three demensions being PU, RR_constraint then material_no.

This formula works for me when looking at the material_no layer in the pivot table but when i collaspe it .to view at the RR_constraint level the values dont add up as i beileve the if is being performed at that level.
if(
sum(Finish_Plan) = 0, sum(Finish_Plan),sum(Actuals_Countable)
)

I tried aggregating it like below at a material_no level and even include the RR_constraint field but again it showing correct values at material_no but when trying to view at the next level 0 is showing. Any idea how i could go about adjusting. I have tried multiple different ways but cant get to work. Data is basic with material_no being a varchar and others fields being decimals.

if(
aggr(sum(Finish_Plan),material_no) = 0, aggr(sum(Finish_Plan),material_no),aggr(sum(Actuals_Countable),material_no)
)

Re: Aggregation in a If statement

Antoine04 — Fri, 01 Mar 2024 14:13:36 GMT

Hello,

Try to add all the fields in your aggr. formula, maybe something like :

aggr(sum(Finish_Plan),PU, RR_constraint, material_no)

Could you share a screen of your exemple ? That would help.

Regards,

Antoine

topic Aggregation in a If statement in App Development

Aggregation in a If statement

Re: Aggregation in a If statement