Need expression

[#1]

Hi all,

   i have a data set like this for the current month i need to show the previous month actual values.and for the

remaining months it should be outlook values(i will get data from jan-dec for every month). !

PFA

[Anonymous]

Hi Sruti,

Can you be bit more clear on your requirement????

[tresesco]

Like this?

If(month=Month(Today()),Sum({<scenario={'actuals'}>}fin),Sum({<scenario={'outlook'}>}fin))

PFA

[#4]

Hi Tresesco,

In the If condition it will take only today month.but wat i need is from jan to today's month it should be actulas

and remaining all are outlook values

[jagan]

Hi,

Then try like this

If(month < Month(Today()),Sum({<scenario={'actuals'}>}fin),Sum({<scenario={'outlook'}>}fin))

OR if you have a date field then try like this

If(DateFieldName < Today(), Sum({<scenario={'actuals'}>}fin),Sum({<scenario={'outlook'}>}fin))

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

I used < in condition, so it will return the values upto the current month.  Or in script you can try like this

Data:

LOAD

*,

'Actual' AS Data

FROM ActualData

WHERE Date < Today();

Concatenate(Data)

LOAD

*,

'Outlook' AS Data

FROM OutlookData

WHERE Date >= Today();

Now in frontend there is no need of conditions at all, you can just use Sum(fin).

Hope this helps you.

Regards,

Jagan.