Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Don't show Total

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

Measuers:

 

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

 

Thanks

Need Help
Show and Tell

2 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi Anonymous,

     

    => 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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

       

      Thanks