I have a formula that, every time I check on it (still editing this widget), one of the fields has reverted from the usual highlighted blue rectangle to just [text]. I can replace it or delete the number 2 and it'll pop back in no problem, but be flattened again next time I check.
Are there any common mistakes I could be making that cause this? Will the formula continue to function the same way even with this happening?
Here is the formula for reference. The [zone2] field near the end is the one causing issue. The [zone2] field is filtered to the same values as [zone] on the third line. Would that cause this?
This is not the first time I've seen this happening, but can't remember how (or if) I fixed it in the past. Thanks in advance for any insight!
This sounds like a Chris Wallingford (Sisense) issue. Otherwise, you could attempt to rename the "Zone2" to the zone description. Sisense might be getting confused due to three closely named fields (Zone, Zone1, and Zone2). I rename them all the time so that I can quickly see what I'm filtering in the formula. To change the name, right click.