set analysis expression

[adiarnon]

hi,

i have this expression-

=Sum({<BU_Year_Quarte>={">=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

it not working!!

this is working-

=Sum({<BU_Year_Quarte>={"=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

whats wrong?

adi

[francoiscave]

Hi Adi,

The best document to manipulate Set Analysis:

Set Analysis: syntaxes, examples

By Fabrice Aunez.

It will be helpful !

François

[mdmukramali]

Dear,

The field name is

BU_Year_Quarte

or

BU_Year_Quarte>

If it's BU_Year_Quarte then try to use the below expression

=Sum({<BU_Year_Quarte={">=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

Thanks,

Mukram

[PrashantSangle]

Hi,

Try like

=Sum({<BU_Year_Quarte>={">=$(=num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

Regards

[adiarnon]

not working   

[adiarnon]

this is working-

=Sum({<BU_Year_Quarter={"=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

but i need

=Sum({<BU_Year_Quarter={">=(num(year(today())&'0'&ceil(month(Today())/3)))"}>}BudgetCurrentBook)

and its not working,,,,

this-num(year(today())&'0'&ceil(month(Today())/3)) -> 201404

and this

=Sum({<BU_Year_Quarter={">=201404"}>}BudgetCurrentBook) -is working

whats wrong?

[tresesco]

'=' works, because it is taken as a text/string comparison.

'=>' won't work( works actually as string comparison rather than numeric), because of non-numerical comparison.

[jagan · Accepted solution]

Hi,

Try like this

create a variable

vCurrentQuarter=num(year(today())&'0'&ceil(month(Today())/3))

=Sum({<BU_Year_Quarte{">=$(=vCurrentQuarter)"}>}BudgetCurrentBook)

OR

if you have datefield in your data model then you can use

=Sum({<DateField{">=$(=QuarterStart(Today()))"}>}BudgetCurrentBook)

Hope this helps you.

Regards,

Jagan.

[yevgeniy]

may be you helped create variable:

year(today())&'0'&ceil(month(Today())/3)

=Sum({<BU_Year_Quarter={'>=$(yourvaryable)'}>}BudgetCurrentBook)