If statement in Set analysis

[v_jaideep]

Hi,

I need sum(sales) only when start date > approved date. How can I achieve this in set analysis .

@tresesco any suggestion

[tresesco]

Try like:

Sum({<Sales={"=StartDate=ApprovedDate"}>}Sales)

[v_jaideep]

Tried above and this Sum({<startdate={">=approveddate"}>}sales)

Both did not work

[AshutoshBhumkar]

Hi,

As @tresesco suggested,

Sum({<Sales = {"=StartDate>ApprovedDate"}>}Sales)

Above expression should work

[v_jaideep]

hello Ashutosh,

I get '0' when I use the above expression.it is not the syntax error when I say that "It doesn't work"

[abhijitnalekar]

Hi @v_jaideep ,

Check if both field date format is same.

[v_jaideep]

Yes, Date format are same.
I got this working when used in the backend and create a flag and using that flag in set analysis.
But now I want the whole condition in set analysis , so that I could save a 'Join' in the script.

[abhijitnalekar]

Can you share sample data or expression which you have used>

[maxgro]

I think you need a Key field (you can create it with autonumber in the script) and then

Sum({<Key = {"=(StartDate> ApprovedDate)" } >} Sales)

[v_jaideep]

Even this didn't work.😫

P.S: Above all options are not syntax errors just the data shown is '0 in my case.