Looking for equivalent expression of set analysis in load script

[vikasshana]

Hi,

I do have the below set analysis expression in one of my straight table. I'm looking for an equivalent expression in load script.

sum({<Date-={'""'}>}Sales).

Can someone help me on this please.

Regards,

Vikas

[Vegar]

Load 

If (Date <> '""',Sales) as CalcSales,

Sales as Sales,

Date as Date

From...

[Colin-Albert]

If your date field is held correctly as a dual or numeric value, then this will work

Load 
If (Date > 0, Sales) as CalcSales,
Sales,
Date 
From xxxxx

Then in your chart use    sum(CalcSales)

I'm not sure why you would have Sales data with nul or empty dates though.