transform data

[BardosHelga]

I need some help about transform data. I have a data base, where find the folow datas: 

When I creat visualization, for example a table, I see the next data:

It is wrong because the data would have to be zero.
What can I do? What I have to do?

Thank you so much!

Helga

[HotChilli]

It's a measure totals issue.  There are many posts about this.

What is the definition of KtgHUF? and are there any other tables/relationships in the model?

[BardosHelga]

KtgHUF means: cost in hungarian currency.

Yes, there are any other tables in the model. Are there 11 sources, I imported all of them from excel. I exported data from SAP to excel. They all work, exept this last one.

Can you help me, how can I find quickly and easy topics, that relevant for me?

Thanks!

[mlsx4]

Hi @BardosHelga 

I think that the problem is that they don't sum because of the column "Konyveles datuma".

If you remove it from the table, does it work?

[BardosHelga]

Hi @mlsx4 

Thank you so much your answer. Unfortunately it doesn't work either.

I don't know what can be the broblem. I have imported many of data to BI, there are many of positiv and negative data, it's an everyday thing. I have never experienced, like this. It seems, there are any data, that BI don't treated as negative data.

[mlsx4]

Hi @BardosHelga 

It can seem stupid but.. have you tried to define a conditional column to check if they are recognized as negative values? I mean if value<0, "True", "False". Sometimes the format of the "-" sign is not the correct one, so you may need to replace it