Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.