Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago
Solved

Measure help

Dear Community,   i have created a margin, which is throwing error, can you let me know what could be the right way to do it?   Margin% = IF(SUM(Inbound[NER_FYTD_Constant]=0,0,SUM(Inbound[MarginF...
Need Help
Show and Tell
  • Christann's avatar
    Christann
    7 years ago

    You have put all of your parentheses at the end! Try:

    Margin% = IF(SUM(Inbound[NER_FYTD_Constant])=0,0,SUM(Inbound[MarginFYTD_Constant])/SUM(Inbound[NER_FYTD_Constant]))

    Hope this helps!

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago

Christann

 

conditional formatting is something i am aware, if you noticed in the pic, there is some indicators(up & down in triangle shape), how can we build that indicators in the table?

Christann's avatar
Christann
Advocate IV
7 years ago

Sure!, take a look at this link from Curbal.com, and see if this is what you needed.