Don't show total =/
This is a measure wiht IF another measure don't heave IF
problem happens on the desktop and the service
Total comprometido_old when I expot to Excel R$ 7.400,00
COMPROMETIDO_old = IF(CALCULATE([TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL]);RELATEDTABLE(PEDIDO)) < 0 ; 0 ; CALCULATE([TOTALPEDIDO] - ([ENTRADACUSTO] + [ENTRADACONTABIL]);RELATEDTABLE(PEDIDO)))
ENTRADACUSTO = CALCULATE([valor_Custo]; CUSTO[FLAGCOMP] = TRUE())+0
ENTRADACONTABIL = CALCULATE([Valor_Contabil]; CONTABIL[FLAG] = TRUE())+0
TOTALPEDIDO = CALCULATE(SUM(PEDIDO[VALOR_PED]);PROJETOS[ENCERRADO] = 13; PEDIDO[ELIM_PED] <> "L"; PROJETOS[ORDEM] <> 0; ALL(MES[MÊS]); ALL(ANOS[ANO]))
Please help me =D
=> problem happens on the desktop and the service
In your scenario, what is the problem? Did you mean the grand total of measure comprometido_old was wrong? And your expected grand total result of comprometido_old is 740000?
Sorry but I'm not quite understand about your issue. Could you please elaborate it? By the way, if you can share us some sample data which can help us repro your issue. It'll help us more to figure out where the issue is.
Thanks Xi Jin.
Well, the problem is that it does not show the total, compromised_old is a measure of the monetary type, it generates a rest of the fields that I listed above.
Look this file: Link To Donwload