Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to build subtotals for the dimension "Ratenschema", but i dont know how to do.
The subtotals should be for the column "Anzahl Paletten (PAE) Formula= [Anzahl Artikel] * factor
How can i avoid the "-" in the fields?
Thanks and regards,
Sabrina
It looks like you are using expressions which cannot be evaluated at a total and subtotal level.
This is usually caused by 'naked fields", ie fields used in the expression not enclosed in an aggregation function (like max(), sum() etc). These field values cannot be evaluated at the total/subtotal level as they have more than one distinct value at that level.
You may need an Aggr() function to calculate this column. Something like:
Sum(Aggr(<your existing expression>, unit_id, Ratenschema)
See also here
You could enable sub-totals within the object properties in tab presentation (top left) and bottom left you could set options how NULL and EMPTY will be displayed.
- Marcus
subtotals is already checked 😞
Have you set the subtotals for each dimension which you want?
It looks like you are using expressions which cannot be evaluated at a total and subtotal level.
This is usually caused by 'naked fields", ie fields used in the expression not enclosed in an aggregation function (like max(), sum() etc). These field values cannot be evaluated at the total/subtotal level as they have more than one distinct value at that level.
You may need an Aggr() function to calculate this column. Something like:
Sum(Aggr(<your existing expression>, unit_id, Ratenschema)
See also here
yes, its done!
try this
It works fine! Thank u all!! 🙂