Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Hi lalit,
try this expression, it will show only positive values..
=if(sum(Amount)>=0,sum(Amount))
hi,
Please check the attached QVW.
Please mark the question as answered if it meets ur requirement .
!
Try this.
Use this expression:
=sum(if(Amount>0,Amount))
I hope this might hekps you
-Nagarjun
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)
try like this:
=if(sum(Amount)>0,sum(Amount),text(sum(Amount)))
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
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))