Total don't show

[Anonymous]

Hi all.

Someone know what can be?

Total of the COMPROMETIDO does not appear

Ty

[v-yulgu-msft]

Hi @Anonymous,

I cannot understand your problem. Please illustrate your scenario with sample data. Also, what does below formula mean? I don't see [TOTALPEDIDO], [ENTRADACUSTO] and [ENTRADACONTABIL] in your screenshot.

"COMPROMETIDO = CALCULATE(IF([TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL]) <= 0; 0 ; [TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL])))+0"

Please provide more information of how to reproduce current result and your desired result so that I can test for you.

Best regards,

Yuliana Gu

[Anonymous · Accepted solution]

When I remove "IF" worked normaly ;D

Don't understand very well but,

I get this data of a ACCESS DB and I change de Column to Fixed Decimal

Just It =/

Ty

[v-yulgu-msft]

Hi @Anonymous,

So, removing "IF" is the solution to above problem and you could get what you expected, right? Thanks for your sharing, would you please mark your sharing solution as an answer? If you still have any question, please feel free to ask.

Thanks,

Yuliana Gu

[Anonymous]

 Have COMPROMETIDO with negative value this calc without this if be equals -11.000,00

COMPROMETIDO = CALCULATE(IF([TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL]) <= 0; 0 ; [TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL])))+0