Set Analysis and Variables (Date)

[Anonymous]

Hello,

I am trying to compatre a date in my aplication with a variable. The requirement is to have a user select a date and then compare it to the variable. I cannot get the syntax to compare the variable to my calendar.

The part in Bold is giving my syntax errors and I cannot get it to work - in spite of trying lots of combinations.

Any advise would be appreciated!

sum(
{<Calendrier.Date = {*},Calendrier.Annee = {*},Calendrier.Mois = {*}, SALES.Salesman_-={"Intercompany"},
Renew1.Renew.Renewal_Date = $(>= vLower_Date )
>} Renew1.Renew.Net_Price )

[sunny_talwar]

Syntax isn't right.. may be try this

Sum({<Calendrier.Date = {*},
      Calendrier.Annee = {*},
      Calendrier.Mois = {*},
      SALES.Salesman_ -= {"Intercompany"},
      Renew1.Renew.Renewal_Date = {">=$(vLower_Date)"}>}
Renew1.Renew.Net_Price)

[Anonymous]

Hi - thanks for your help - i'm aware that it's a syntax issue - i'm still having errors with your syntax though

[sunny_talwar]

What is the error message that you get?

[Anonymous]

Errors in expression -so a syntax error 

[sunny_talwar]

Would you be able to share a screenshot of your syntax editor? I mean is it possible that you have incorrectly typed one of your field names, like is the field name 

SALES.Salesman_

or

SALES.Salesman

[Anonymous]

Hi i've reduced it down as much as possible. I'll try to make a simple app if you think that's better

[sunny_talwar · Accepted solution]

Try this

Sum({<Calendrier.Date = {"*"},
      Renew1.Renew.Renewal_Date = {">=$(vLower_Date)"}>}
Renew1.Renew.Net_Price)

[Anonymous]

Thank you so much 🙂