Pivot Expression

[upaliwije]

In my pivot Table the following expression is working fine

=SUM({<I_MONTH = {"$(=Only(I_MONTH))"},I_DAY = {">25"}>} [PREMIUM])

But the expression given below returns 0 value

=SUM({<I_MONTH ={"$(=Only([1_MONTH])-1)"},I_DAY = {">25"}>} [PREMIUM])

Can some pls tell me what is wrong with 2nd expression

[#2]

maybe this difference is a problem:

Only(I_MONTH

Only([1_MONTH])-

[#3]

Use the below expression as 2nd expression and see if this works, I have added () to Only(1_MONTH)

=SUM({<I_MONTH ={"$(=(Only([1_MONTH]))-1)"},I_DAY = {">25"}>} [PREMIUM])

[#4]

Can you try below:

=SUM({<I_MONTH ={"$(=$(=Only([1_MONTH]))-1)"},I_DAY = {">25"}>} [PREMIUM])

Thanks,

Angad

[tresesco]

Two possibilities:

• typo - [1_MONTH] or [I_Month]
• If your [1_Month] field is not numeric 'only([I_MONTH])-1' would not work for obvious reason.

[jagan]

Hi,

What is your I_MONTH values format? Is it 1,2,3,4,etc.  If it is numeric then try below expression

=SUM({<I_MONTH ={"$(=Only([I_MONTH])-1)"},I_DAY = {">25"}>} [PREMIUM])

Also you are using 1_MONTH (numeric month) please check.

Regards,

Jagan.