Ignore date selection (dimension field)

[#1]

Hi,

I need the below expression to ignore my selection in dimension field Date

Cannot get it to work properly for some reason, any suggestions?

//O

=If(sum(SoD_Pmt_amount) <> 0,

If(Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),4) = 0,
If(Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),3) = 0,
If(Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),2) = 0,

If(Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1) = 0,

Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),5),
Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1)),
Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1)),
Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1)),

If(Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),2) = 0
and
Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1) = 0,

Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),3),
Above(sum(if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1))))

[sunny_talwar]

Try and see if this works:

Put {<Date = >} or {<Date = {'*'}>} after Sum everywhere you see Sum

Best,

S

[#3]

Tried this but getting the very same result.

=If(sum({<Date = >}SoD_Pmt_amount) <> 0,

If(Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),4) = 0,
If(Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),3) = 0,
If(Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),2) = 0,

If(Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1) = 0,

Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),5),
Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1)),
Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1)),
Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1)),

If(Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),2) = 0
and
Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1) = 0,

Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),3),
Above(sum({<Date = >}if(SoD_Pmt_Subtype='Credit line connected payment',SoD_Pmt_amount)),1))))

[sunny_talwar]

Tested on our previous post's expression and it works:

Sum Previous Date

=If(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)) <> 0, If(Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),4) = 0,

If(Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),3) = 0, If(Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),2) = 0,

If(Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1) = 0, Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),5),

Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1)), Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1)),

Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1)), If(Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),2) = 0 and

Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1) = 0,

Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),3), Above(Sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1))))

Sum Date

=sum({<Date = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount))

Best,

S

[sunny_talwar]

Take at the application, may be you can figure out the difference. PFA

Best,

S

[#6]

problem occurs for the first date when you select a specific month. Pls see below:

[sunny_talwar]

So the thing to note here is that by putting in {<Date = >} you are telling the expression not to change based on any selection in Date listbox. In your case you made a selection on Month-Year list box which will not stop the expression to change. To tell the expression not to change on Date and Month-Year selections you would put this:

{<Date = , Month-Year = >}

So now if there are any other fields that you don't want your expression to change on, put them there in your set analysis modifier.

This below expressions won't change on any selection in Date and Month-Year listbox

Sum Previous Date

=If(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)) <> 0, If(Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),4) = 0,

If(Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),3) = 0, If(Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),2) = 0,

If(Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1) = 0, Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),5),

Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1)), Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1)),

Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1)), If(Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),2) = 0 and

Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1) = 0,

Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),3), Above(Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount)),1))))

Sum Date

=Sum({<Date = , [Year-Month] = >}if(Pmt_Subtype='Credit line connected payment',Pmt_amount))

Output:

Value for 2014/11/28 Sum Previous Date is blank because the data starts from 2014/11/28, so there is no previous date value to display (i.e., 2014/11/27 value)

HTH

Best,

S

[#8]

Aaa, I see that explains.

In my case im generating a report for every month so I just wanna see the december dates.

Is there a way of just showing the selected month? For instance if I select December-2014 I wanna see all of the december dates only, but with the calculations intact, meaning that I wanna see the prev date sum för 1-dec too

[#9]

I wanna select December and see the below Only, no novermber dates.

[sunny_talwar]

Yes there is a way to do that. I am working on it and will respond when I have the solution for you.

Best,

S