Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Guys
i have data in attached excel
let say if i select Field , let say
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
Do you want to sum or count the remaining rows?
=Sum({1-$} [Material count])
What are you getting and what do you expect to see?
Hi,
does aggregation function really matters? in few conditions i want count and in few i want sum too
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?
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
