Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I think, i am missing something, if any one can point out the error i am doing, it will be great.
I want a calculation like this
sum({<ID_PERIOD = {">=0"}, ID_PERIOD = {"<=2078052"}>}QTE_VENDU)
I want to compare the ID_PERIOD falls between VALUE1 and VALUE2
When i enter the values directly it works. but they are fields in table so i did these two things
sum({<ID_PERIOD = {">=P(SAIS_SEM_DEB)"}, ID_PERIOD = {"<=P(SAIS_SEM_FIN)"}>}QTE_VENDU)
sum({<ANNEE_SEMAINE=, ID_PERIOD={"'>='&P(SAIS_SEM_DEB)&'<='&P(SAIS_SEM_FIN))"}>} QTE_VENDU)
Both brings 0 Sum value.
Thanks in advance for your help.
Regards
Jegadish
After going through the community discussion.
I created a field with Recno() named as rec_num and then used the set analysis tool generator to solve my problem.
Sum({$<ANNEE_SEMAINE=,REC_NUM=P({1<ID_PERIOD={">=$(=P(SAIS_SEM_DEBUT_))"}>}REC_NUM), REC_NUM=P({1<ID_PERIOD={"<=$(=P(SAIS_SEM_FIN_))"}>}REC_NUM)>}QTE_VENDU)
hello
it could mean that your 2 fields do not contain the values you think
try to display them in text boxes , select the period you want and look at the values
Hi,
Expressions seems to be correct, can you post some sample data..
i want to calculate the quantity (QTE_VENDU) when the ID_PERIOD falls between SAIS_SEM_DEBUT and SAIS_SEM_FIN irrespective of my period selection.
i used this expression
sum({<ID_PERIOD = {">=P(SAIS_SEM_DEB)"}, ID_PERIOD = {"<=P(SAIS_SEM_FIN)"}>}QTE_VENDU)
= 0
when i use a hard value
sum({<ID_PERIOD = {">=0"}, ID_PERIOD = {"<=2078052"}>}QTE_VENDU)
It works correctly
Not able to find the error, help appreciated.
After going through the community discussion.
I created a field with Recno() named as rec_num and then used the set analysis tool generator to solve my problem.
Sum({$<ANNEE_SEMAINE=,REC_NUM=P({1<ID_PERIOD={">=$(=P(SAIS_SEM_DEBUT_))"}>}REC_NUM), REC_NUM=P({1<ID_PERIOD={"<=$(=P(SAIS_SEM_FIN_))"}>}REC_NUM)>}QTE_VENDU)