Hi Marvin - thanks for posting your question.

In TrendMiner, we have an IF function similar to Excel - you can find it in Tag Builder → Formula.

Please let me know if you have any further questions!

Kevin

Ok, but what would be the entry for X? if(X,Y,Z)

The If function isnt the same as iferror 

Hi Marvin - the entry for X would be the bad value you are trying to replace. Did you have a specific value in mind for your tag? How does the tag show up in TrendMiner when the value is bad?

Kevin

Hi Kevin,

the tag in trendminer shows no values. In PI Vision its shown as “bad”. My Problem is that any formula including the tag will be empty aswell. So i would like the tag to show 0 instead.