Set to return a value from a table

[#1]

QV Gurus, one and all

I have been stumped on this one for quite a while.

I have a table which has four headings...Area, MinPt, MaxPt, DaysHence

I need to develop a set that returns the value in DaysHence, where the result of a forumla within the same table (let's call it TP) is greater than MinP and less than MaxP

I have tried combinations of the following with max, Only, Sum, Min etc, but to no avail.

=sum({<MinPt = {"<=[TP]"},MaxPt = {"<=[TP]"}>}DaysHence)

I believe the problem will lie with the use of the Field name [TP]...would anyone know a way around it?

The forumula that creates [TP] is a combination nested if/set evaluation using two programmable variables, so i donlt know if it can be included in it's raw form

Thanks in advance

Rick Green

[anbu1984]

=sum({<MinPt = {"<=[TP]"},MaxPt = {">=[TP]"}>}DaysHence)

[sujeetsingh]

Rick,

As per my level of thinking i will define this new field in script with checking nested iff conditions.

Just do it and iff needed then provide a sample

[#4 · Accepted solution]

Thank you all for your help. In the end I created a new table in excel with all the possible values (value will never go over 2000) and have referenced that directly, rather than try the greater than and equal to approach.