AnsweredAssumed Answered

Calculated data using self determined string as an input.

Question asked by WCBrad on Sep 14, 2016
Latest reply on Sep 15, 2016 by Roger Palmen

Hi all, I am developing an operational performance database and have included a structure for an alerts and limits system. To aid in maintenence and development the values and their states have been set up in a table where each row is identified using a unique identity consisting of the Asset number and the attribute name. These identities are created using the stringbuilder with |FLN;_;%|Attribute%; The final output is determined using a formula function nested if statement to return a value as defined in the lookup table. However, Using calculated data on the result to return the average alert state results in no good data. Querying elsewhere using compressed data it says that the Identity has no time information and so cannot return a value. If anyone has any thoughts as to what may be happening or how to write a similar structure, it would be greatly appreciated. Regards, Hi all, I am developing an operational performance database and have included a structure for an alerts and limits system. To aid in maintenence and development the values and their states have been set up in a table where each row is identified using a unique identity consisting of the Asset number and the attribute name. These identities are created using the stringbuilder with |FLN;_;%|Attribute%; The final output is determined using a formula function nested if statement to return a value as defined in the lookup table. However, Using calculated data on the result to return the average alert state results in no good data. Querying elsewhere using compressed data it says that the Identity has no time information and so cannot return a value. If anyone has any thoughts as to what may be happening or how to write a similar structure, it would be greatly appreciated. Regards

Outcomes