how to get previous day value

[ravindraa]

Hi all,

  I have struck in one place my requierment is we have to display the values

day wise if the selected day is sunday then we need to pick previous day(saturday).

i wrote expression like below

if

(weekdate_Orderdate='Sun',(Num(Count({<Type={'B'},Day={"$(=Day-1)"},B_ExecutionFlag={'1'}>} DISTINCt If([Execution Interval]<=V_FFR_U,[Sales Doc.],nULL()))
/Count({<Type={'B'},Day={"$(=Day-1)"}>}DISTINCT [Sales Doc.])*100 , '##.##')),


Num(Count({<Type={'B'}, B_ExecutionFlag={'1'}>} DISTINCt If([Execution Interval]<=V_FFR_U,[Sales Doc.],nULL()))
/Count({<Type={'B'}>}DISTINCT [Sales Doc.])*100 , '##.##')
)

please  give me any suggesion on this.

Thanks in advance.

[ravindraa]

Hi Experts,

I am sending sample data image find below the same.

above screen shot june 28 is Saturday it is giving exact value.

NM(Numarator)

DNM(Denaminator)

totalvalue(NM/DNM)

NM Exclude sunday= i mean it should be display the previous day if the selection is sunday.

if i select Sunday (June sundays-8,15,29) in NM exclude Sunday colum it is showing Zeros.

Actuvaluy above expression need to display the value selected day value, when the days is sunday it has to be display the Saturday value.

After select the Sunday it is showing Zero value please find the below screen shot.

  Please give me any one suggesion on this.

Thanks in advance.