Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
I hope the screenshot is self explaining.
My expression for column C is simply deviding 2 columns A and B by eachother
The Total lines of column A and B are set to sum.
How to get the Total line of C to match the total of A / total of B.
I have tried with sum aggr total... but fail to get the result i am looking for.
thanks,
Jan
Hi
Can you please use the expression below
=If(Dimensionality() = 0,Sum(Total Aggr(SUM({<Type={'SCRAP'}>}Qty)*Price,Part,Coef)) / Sum(Total Aggr((SUM({<Type={'Produced'}>}Qty) - SUM({<Type={'SCRAP'}>}Qty))*Coef,Part,Coef)),SCRAPPRICE/OKCOEF)
Thanks
Kushal
Your screen shot is corrupted. Upload a new one.
From my understanding, you can use Expression total or sum of rows in Expression tab Total Mode option.
Does this work ?
Instead of sum of Rows. Use the Above option Expression Total
I tried "Expression Total" already.
Its resulting in a '-' as total.
Adding a simplified QVW
How to get the totals of A/B --> 11/8 = 1.375
Is this what you want?
Also you can use Column(1)/Column(2)
Unfortunately real life is a bit more complex than the example i attached previously.
I tried to make my demo qvw 1 step closer to what i have in reality...
Putting the SUM(A)/SUM(B) as you proposed is returning "-" in the sample attached same as it does in my real life scenario.
See attached.
Hi Jan
you can use below expression for the attached qvw
If(Dimensionality() = 0,sum( total A)/sum(total B),Sum(A)/Sum(B))
Thanks
Kushal