Swaroop.gatela this works great however for something things to takes 74.32 and turns it into ,74 when the data is 74.32 and I'm not sure why. Ideas or direction I can get without sending you data?
Hmm. Are your values coming out of a dataset or are they calculated?
Maybe you can just post a few de-identified rows.
I should have noted earlier that in the example I posted, Value2 is only for
display purposes, but for actual presentation of bars of other calculations,
you would still need to use the original values.
It is a calc unlike the others, yes. Sum(totalrev)/sum(Numberofnights)
I've never de-identified rows not even sure what that is.
I've created a simple mockup and working to reproduce the problem.
The attached twbx uses a calculation, but does seem to be formatting correctly.
I thought it might be due to mixing to datatypes with whole and decimal numbers,
but that doesn't seem to affect it.
I've attached here some mock data, would be grateful if you would adjust it match
more close your real data.