Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I think Straight Table is not right !
Background:
In my data model, OrderId repeats multiple times. and this is how the data model looks
What I am trying to do?
I want to see how many products are delivered and how many are shipped
I am using below expressions in straight table
For Total Delivered : =num(Count(Distinct{$<StatusId={1}>}OrderId),'##,###,###')
For Total Shipped : =num(Count(Distinct{$<StatusId={2}>}OrderId),'##,###,###')
And I get this straight table
It looks right but shouldn't the total of delivered product be 4? instead of 2?
I have attached sample QVD with data.
Thanks
lol sunny took screenshot and attempted to attach QVW so I thought i should mark you as correct answer compare to Kushal's short answer
but jokes apart.. and thank you both for replying my post.
Thanks for recognizing both our efforts
nahi bhai muje is helful k 50 points milne wale the isliye bola
je baat
May you can earn more points by answering my another question?
I wish I had any experience in NPrinting to help you out
no worries.. may you can answer this question then