Pivot Table / Straight Table Expression Help - RangeMax Not Working

[pnn44794]

Hello:

I have both a straight table and a pivot table that.

Any ideas?  As always, any and all help is appreciated.

[sunny_talwar]

May be, just may be, you want this

Num(Sum(RangeMax("FB_Finance Confirmed 2017 Savings", 0)),'$#000.0')

[pnn44794]

Ok.  I tried it without the beginning and ending double quotes and reloaded.  Total Saves is now blank.  No values at all.

[pnn44794]

Interesting.  When I paste your suggestion, Sonny, into a Text Object, it works.

[sunny_talwar]

Parry my name is Sunny (not Sonny), just like yours is Perry and not Parry ...

I don't have too much information, but I think the problem is related to dollar sign expansion which is evaluated once per chart... I might be wrong here, but without having a look at a sample (like always) it is aiming for the target in dark

[pnn44794]

Sorry Sunny for the typo. I know it’s Sunny. No offense meant. I’ll get some sample data together and will post it in a little while.

[sunny_talwar]

None taken my friend . I didn't mean to offend, but I don't understand why people some time call me Sonny or Sunni when my name clearly says Sunny

[pnn44794]

I truly fat fingered it. Tired. I need to get some sleep, but I need to get this and a few other things working.

BTW, the straight table is now totaling up as expected using "Num(RangeMax(Sum("FB_Finance Confirmed 2017 Savings"), 0),'$#,000')" from within the load script. This is very weird. So now it’s just the Pivot table where RangeMax is including negative values. Again, I’ll get some sample data together. Thanks.

[pnn44794]

Hello Sunny (and anyone else who may be following this discussion thread).  Any ideas why I might be picking up the negative values with RangeMax?

[pnn44794 · Accepted solution]

I figured it out.  Sunny your potential solution of Num(Sum(RangeMax("FB_Finance Confirmed 2017 Savings", 0)),'$#000.0') was very close.

Here's what I was using within my Load script and which was including the negative values:

"Num(RangeMax(Sum("FB_Finance Confirmed 2017 Savings"), 0),'$#,000')" <-Double quotes are needed as this is an expression for a user customizable chart

Here' what works and which excludes the negative values.  What I changes is highlighted in red:

"Num(Sum(RangeMax(0, "FB_Finance Confirmed 2017 Savings")),'$#,000')" <--I put Sum in front of RangeMax (Sunny's suggestion) and moved the 0 to the first position/parameter for RangeMax