Syntax help please...

[samvile18]

Hi all,

I'm trying to add two different set analysis strings to the results of an IF statement, this is what I need to do:

I need to sum everything when ExtractDate equals my vJanEnd...can someone help me with the set analysis syntax please?

[giakoum · Accepted solution]

Assuming that vJanEnd is a variable :

sum({$<ExtractDate]={"$(vJanEnd)"}>} [YourField])

[samvile18]

You're a HERO

[giakoum]

I seriously doubt that...