Exclude total

[nareshthavidishetty]

Hi,

I have used the below condition to exclude a date from the total.

But now the logic changed.Can you please let me know the right query.

Condition:

Dimension:

Date

=pick(match(WeekDay(Date),'Mon','Tue','Wed','Thu','Fri','Sat','Sun'),'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday')

Expression:

=If(Dimensionality() = 0,

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY),

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())-1) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY))

New Expression:

If(Date>='12/30/2016' , sum(Product$LY),sum(Dollar$LY))

Note: I need to replace the new expression with old expression

For reference above highlighted code is used to remove the total from the below highlighted image.

Thanks..

[sunny_talwar]

I am not sure I understand what exactly is your required output?

[nareshthavidishetty]

Hi,

The excluding the value of 1st date from the total.

I need to replace the New expression (If(Date>='12/30/2016' , sum(Product$LY),sum(Dollar$LY))) with

=If(Dimensionality() = 0,

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY),

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())-1) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY))

Thanks..

[nareshthavidishetty]

Re: Exclude total

nareshthavidishetty Dec 5, 2016 1:53 PM (in response to Sunny T )

Hi,

The excluding the value of 1st date from the total.

I need to replace the old expression

=If(Dimensionality() = 0,

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY),

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())-1) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY))

with  (If(Date>='12/30/2016' , sum(Product$LY),sum(Dollar$LY)))

Thanks..