Expression Help (Count)

[ajaysingh29]

Hi All,

Need your help, I have a pivot table in which I wanted to display count of +ve/-Ve values & actual sum in third column.

I am using following formula in expression :

=count({$<[ Amount]={'<0'}>}[ Amount])  &

=count({$<[Amount]={'>0'}>}[ Amount]) 

However its showing me values  which are $-0 & $0.00. I don't want to consider these records in my pivot object.

Thanks in advance.

[avinashelite]

Exactly that's what I am trying to mention on either side of the = we cannot have an expression in Set Analysis this seems to be fishy for me manojqlik‌ could share the app where its working and how it will work ?

[sdmech81]

@Ajay,  Please share the screen/Example how it worked for U??

I did try but it didn't work ..

Sachin..

[#4]

Count({< [Amount] = {'>0'} >} [Amount])---Positive Values

Count({< [Amount] = {'<0'} >} [Amount])--Negative Values

[sunny_talwar]

Hahahaha strange that it worked for Ajay

[#6]

Hi experts,

I did not test it , whether it is working fine or not

Randomly I have given the reply ,

If I get sample data will test it .

[#7]

I request Ajay Singh to explain how it helped him to achieve the result