Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a question about creating a Grand Total count in an Chart Expression, based on the data in other Expressions.
In my Chart, I have 7 Expressions (Deviat...), counting False values from my data. I want to create one Expression counting the total sum of all False-values from the other 7 Expressions (GrandTotalDeviations). Is this possible to do?
The syntax I've used in my 7 Expressions are pretty much the same, and in ex. DeviateWidthCU it's like:
IF(ViewKontrollMaling.Pakningsniva like 'CU',
IF(SUM(ViewKontrollMaling.KontrollMaltBredde+Toleransegrenser.MalTorr+0.0001)
> SUM(ViewKontrollMaling.OpprinneligBredde), 0, 1)
OR
IF(SUM(ViewKontrollMaling.KontrollMaltBredde-Toleransegrenser.MalTorr-0.0001)
< SUM(ViewKontrollMaling.OpprinneligBredde), 0, 1))
I am not sure if this is usefull for you or if I understand you correct, but if you want to count the outcome of different expressions, you can just work with the function Colunm()
fe: Column(1) + Column(2) + Column(3) + Column(4) + Column(5) + Column(6) + Column(7)
Is that what you are looking for?
I am not sure if this is usefull for you or if I understand you correct, but if you want to count the outcome of different expressions, you can just work with the function Colunm()
fe: Column(1) + Column(2) + Column(3) + Column(4) + Column(5) + Column(6) + Column(7)
Is that what you are looking for?
if you have more than one dimension then
go to chart properties
seleect first dimension-> check partial sum -> check subtotal on bottom
seleect second dimension-> check partial sum -> check subtotal on bottom
hope this help