Invalid formula: Unknown function/operator

HCL Domino Domino Forum
1

Hi. My users (Notes client 6.5.2) got this message in a categorized column view “Invalid formula: unknown function/operator”. I have Notes client 6.0.2 and everything is running normal. This is the column’s code:

allstatusmfg:=pcnstatusmfg;

nombresmfg:=pcnmfg;

imfg:=@Elements(allstatusmfg);

nummfg:=@Sum((imfg): (- imfg): (- imfg): 1);

allstatusing:=pcnstatusing;

nombresing:=pcningproc;

iing:=@Elements(allstatusing);

numing:=@Sum((iing): (- iing): (- iing): 1);

allstatuscal:=pcnstatuscal;

nombrescal:=pcncalidad;

ical:=@Elements(allstatuscal);

numcal:=@Sum((ical): (- ical): (- ical): 1);

@While(imfg > 0;

		nommfg:=@Subset(nombresmfg; 1);

		statusmfg:=@Subset(allstatusmfg; 1);

		@If(statusmfg="Pendiente Por Aprobacion"; finalesmfg:=finalesmfg:nommfg; "");

		nombresmfg:=@Subset(nombresmfg; nummfg);

		allstatusmfg:=@Subset(allstatusmfg; nummfg);

		imfg:=@Elements(allstatusmfg);

		nummfg:=@Sum((imfg): (- imfg): (- imfg): 1));

@While(iing > 0;

		noming:=@Subset(nombresing; 1);

		statusing:=@Subset(allstatusing; 1);

		@If(statusing="Pendiente Por Aprobacion"; finalesing:=finalesing:noming; "");

		nombresing:=@Subset(nombresing; numing);

		allstatusing:=@Subset(allstatusing; numing);

		iing:=@Elements(allstatusing);

		numing:=@Sum((iing): (- iing): (- iing): 1));

@While(ical > 0;

		nomcal:=@Subset(nombrescal; 1);

		statuscal:=@Subset(allstatuscal; 1);

		@If(statuscal="Pendiente Por Aprobacion"; finalescal:=finalescal:nomcal; "");

		nombrescal:=@Subset(nombrescal; numcal);

		allstatuscal:=@Subset(allstatuscal; numcal);

		ical:=@Elements(allstatuscal);

		numcal:=@Sum((ical): (- ical): (- ical): 1));

@Unique(@Trim(finalesmfg:finalesing:finalescal))

I read in some pages that this could be happening by the client’s version but i don’t think so because mine is older than my users have. Could your help me? I really need a good answer.

Thanks.

2

Subject: RE: Invalid formula: Unknown function/operator

The column formula is not evaluated by the Notes client unless you use a local replica. In a server replica, the server evaluates this formula. So, what is the version of your server?

BTW, is this your entry in the Obfuscated Macro Code contest? For instance, what is this supposed to do?

nummfg:=@Sum((imfg): (- imfg): (- imfg): 1);

Seems to me it means the same as

nummfg := 1 - imfg;

only less efficient. Then you have these while loops. Rather than a simple counter which you increment each time, you have two counters – one to count up and one to count down, apparently – and rather than incrementing or decrementing them, you each time remove an item from a list and then count the remaining items.

3

Subject: RE: Invalid formula: Unknown function/operator

Server version is 5.0.12. Like you said, it means the server is not recognizing one formula, but which one?

@sum

@subset

@unique

@while

@unique

@trim

@elements

@if

Where can i find this information? Thanks.

4

Subject: *Certainly @While is one of them

5

Subject: RE: Invalid formula: Unknown function/operator

In the Designer 6 help, there’s a whole “What’s new” section that lists all the new commands and functions. Additionally, each new @Function contains a note such as the following:

Note This @function is new with Release 6.

Next time please read the documentation first, before asking.

6

Subject: RE: Invalid formula: Unknown function/operator

just read this last post and Andre I think you’re harsh in your reply!

As most of us are aware, help isn’t always that straightforward, so your sort of comment - especially in such a rude manner, is quite unnecessary!

I hope someone is as helpful to you the next time you need it!!

7

Subject: RE: Invalid formula: Unknown function/operator

Um, no – the reply was appropriate, and phrased much more kindly than is traditional. (The usual is a simple, brusque “RTFM!”.) The documentation is supplied with the product for a reason.

8

Subject: RE: Invalid formula: Unknown function/operator

To be fair, once the issue was framed by Andre pointing out that it is the server version that determines what formulas are valid, the fellow did ask “where can I find this information?” As anyone who programs knows, sometimes the thing is staring you right in the face in your code or in the doc, but you just don’t see it.

When someone says “RTFM” to me (yes, it happens!) I usually retort “which FM?” After all, if I had known where to look, I wouldn’t have asked the question!