listing according to additional data of some rows

[mhamurcuoglu]

Hi everyone,

I want to clarify my question. Think about there is a database that shows composites analysis results. But, for some level of results, additioanl re-test (detailed analysis) performed. Total database will become generally not detailed analysis data. But inside there will be some additional detailed analysis results. I want to filter in the summary report to see farm data as;

• If there is no detailed analysis of the farm, I want to see the result of "No" answered.
• If for the same number of farm (the same ID), there is a detailed analysis results, instead of "No" answered data, I want to see at the same list "Yes" answered data.
• At the end, summary report will show the lowest level of analysis results in the same place. (instead of farm 02's "No" answer, it will be farm 01, farm 03 and "Yes" answered result of farm 02)

Thanks

farm id	detailed analysis	Analysis results	# of actives
farm 01	No	100	15
farm 02	Yes	50	20
farm 02	No	150	20
farm 03	Yes	90	50

Message was edited by: mehmet hamurcuoglu

[Mark_Little · Accepted solution]

Hi,

I am not a 100% on what your are trying to archive.

But you can check the Condtion on the true false using the Peek or previous function.

Something like

Load

...

IF( ID =PEEK(ID,-1),

     IF( (condtion = 'False' AND Peek(condition,-1) = ' True') OR (condtion = 'True' AND Peek(condition,-1) = ' False'),

          'Your Calculation')

     ) As New Field

....

From Table

Order By ID;

Mark

[sunny_talwar]

What is the expected output and in which object you want it in?

[mhamurcuoglu]

for pivot table and output is below

sum(weight*#ofbox)

[maxsheva]

You may do in script

if(condition='True',weight*[#ofbox],0)

or as expression

Sum({<condition='True'>} weight*[#ofbox])

[sunny_talwar]

I was looking for the numerical output....

[mhamurcuoglu]

I changed my responsibilities Sunny

hope is understood

I'm sorry for my english level

[arvind1494]

if(condition='True',weight*[#ofbox],0)