Logic Help

abhaysingh · ‎2016-03-29

HI Guys

i have data in attached excel

let say if i select Field , let say

1001

805115

than report should show rest of the rows and in total count 805115 , shud be excluded.

i m trying to do this like count({1-$}Material count)

but getting wrong result

swuehl · ‎2016-03-29

Do you want to sum or count the remaining rows?

=Sum({1-$} [Material count])

sunny_talwar · ‎2016-03-29

What are you getting and what do you expect to see?

abhaysingh · ‎2016-03-29

Hi,

does aggregation function really matters? in few conditions i want count and in few i want sum too

swuehl · ‎2016-03-29

Well, it might matter with regard to what you are expecting as a result, right?

So, as Sunny also asked for, could you describe what you get and what you expect to get?

abhaysingh · ‎2016-03-29

even after using below condition

count({1-$ < Flag = {'TXN'}>}MaterialCount)

My count value is getting increase as actual count, not able to understand why..

pls suggest

Related Topics