Need logic help

[lalitkgehlot89]

I attached file,

I want to show only the sum of Positive numbers. and in table all number should be present (Positive & Negative).

Thanks,

Lalit kumar

[hemachandran]

Hi lalit,

try this expression, it will show only positive values..

=if(sum(Amount)>=0,sum(Amount))

[fashid]

hi,

Please check the attached QVW.

Please mark the question as answered if it meets ur requirement .

!

[nagarjuna_kotha]

Try this.

Use this expression:

=sum(if(Amount>0,Amount))

I hope this might hekps you

-Nagarjun

[Anil_Babu_Samineni]

I don't have license, Can you please check for this on your application whether this is working or not

=sum({<Amount = {'>0'}>} Amount * 1)

[Frank_Hartmann]

try like this:

=if(sum(Amount)>0,sum(Amount),text(sum(Amount)))

[harishkumarg]

Hi

Please find the attached app.

Expression:

if( Dimensionality()=0 , sum({<Amount={">0"}>}Amount) , Sum(Amount) )

Few changes in the Presentation Tab,

Hope this helps!

Regards

Harish

[sunny_talwar · Accepted solution]

If in case you have more than one amount value per Prod and you want to check if the Sum(Amount) is greater than 0, then try this

=If(Dimensionality() = 0,Sum({<Prod = {"=Sum(Amount) > 0"}>}Amount), Sum(Amount))