pivot plugin

[arie]

If you turn off number formatting everywhere, so it's just plain old dotted decimal with no thousand sepchars, does it total correctly?

If I remove the number formatting on the pivot plugin the total is still wrong however if i remove the number formating on the summed elements, the total is correct!

 

[cheesegrits]

Yup, that's pretty much what I expected. Hmmmmm.

The only thing I can do is assume that the element you are summing will have the same number format you specify in the pivot plugin settings, so I can apply an unNumberFormat() function to it.

Try this:

https://github.com/Fabrik/fabrik/commit/3147a8348543ac93bcaec17607f541925635c9d6

-- hugh

 

[arie]

doesn't work!

 

[cheesegrits]

Oh well, I guess you'll just need to use a calculator.

I'll take another look.

-- hugh

 

[cheesegrits]

OK, try again.

I was using small numbers, so never got as far as thousands, and I'd forgotten to put in that #32 to space fix for thr thousand sepchar in the unNumberFormat() function.

https://github.com/Fabrik/fabrik/commit/7626905518d17c7f115bb1230410418efbfb2579

-- hugh

 

[arie]

well done!
thkx

 

[cheesegrits]

Yay!

BTW, was it you wanted the option to on whether to replace spaces with 0's in cells? So if a cell has no total, you can either leave it blank, or insert a (number formatted) 0?

-- hugh

 

[arie]

I don't remember but i could be nice. This would applied on pivot plugin only or on simple list elements as well?

 

[cheesegrits]

I just noticed that I'd added some handling in the 3.0 pivot to replace 0's with blanks, and I can't remember why or who I did that for, but it was probably you as I think you were th eonly person I did any work for in the 3.0 pivot. So I was just wondering if you needed that feature in 3.3. But I think it needs to be optional behavior.

Just the pivot.

-- hugh