Calculated field

[Syndicate_Admin]

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!!!

[Syndicate_Admin]

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 🙂

[PoweredOut]

You can try

test = if([Total Ciclo] = BLANK(), BLANK(), DIVIDE([Total Ciclo], [OtherMeasure], 0)+0