sum() acts strange

[Anonymous]

Hi All, May be am doing a silly mistake, But what might give me this result. What exactly "12/30/1899" mean?? Please find the screenshot.

sum(budget) give 12/30/1899

and avg(budget) give 0.47.

If there are multiple records, sum should be multiples of avg. But how its displaying 12/30/1899.

[Anonymous]

Kushal, Am not able to reproduce the situation. It's not happening now. I just want to know what might have happened.:(

[Anil_Babu_Samineni]

Your original question is not clear, I would highly asking you to create sample data atleast 5 rows and then tell us your expected result in UI. So then we can help you

[sunny_talwar]

Can you at least share some screenshots? May be while loading your data you need to use Num(Sales, '#,##0.00) as Sales

[Anonymous]

Sunny, the screen shot i have attached in the question is the only one i have. Am not getting the issue anymore.

The changes i did are removing a sync table. And with that the issue is gone. Am not sure what exactly happened. Thinking there might be some thing i did it wrong which converted by decimal number to a invalid date format value.

Thank you guys for your time.

[sunny_talwar]

I am still not sure what exactly are you saying here

Here you mentioned that the issue was while retrieving the data from Excel. But in your screenshot you are showing a straight or pivot table with the incorrect formatting?

[Kushal_Chawda]

Sunny, that is why I suggested to check the Straight table Number format. May there was a format of date

[sunny_talwar]

It seems that the formatting might have been set as date on the number's tab, is that what you are thinking happened also?

[Kushal_Chawda]

exactly bhai.. aapun ye hi bolna chahta

[Anonymous]

No guys, The format was Expression default. I checked that. Leaving the straight table aside, when I preview the data with a Ctrl+ T I was looking at 12/30/1899. as value.

[sunny_talwar]

That's exactly what I meant... if you see 12/30/1899 in data model, then you could have tried Num(Sales) to see if that fixed the issue... but since its already resolved, you should be all good....

Please close this thread if you have got what you wanted. You can mark assumed answer or your own response as correct

Best,

Sunny