Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Calculated field

Good morning

What should I do so that when I use a calculated field in the tables or graphs it does not show me 100% in future months where I still have no information: From June down it should be blank and not with 100% compliance.

Thank you!!!

2 Replies

  • PoweredOut's avatar
    PoweredOut
    Resolver I
    3 years ago

    You can try

    test = if([Total Ciclo] = BLANK(), BLANK(), DIVIDE([Total Ciclo], [OtherMeasure], 0)+0
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Good morning, thank you very much for the solution. so I stay the formula

    Accuracy in Value = IF(sum(Value[Total Inventory])=BLANK(),BLANK(),[Exa Valor])
    And I already have blank the months that I have no data 🙂