Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Expression to Calculate - Opportunity WIP(From History), vDays(a variable return Integer) Back from Today.
Please check attachments.
hi ankit ,
before answering i want to make it clear is that what i understood you want
do you want to enter no of days like 30,15,25 etc from a input box
and you need opportunity wise op-123 ,op-124 and whatever opportunity size wise back from today?
anant
Ankit please explain what you want
rightly sail from input box i want to enter Days(integer values) like i selected 15.
eg -for opportunity - OP-123 , on 16-12-2013(by Exp- Today()-15) WIP stage was WIP 5.
So 15 days back for OP-123 WIP stage was WIP 5
and for OP-124 WIP Stage was WIP 4
now if i change vDays to 30.(on date 01/12/2013)
Than for OP-123 WIP stage is - WIP 3
for OP-124 WIP Stage is - WIP 3
i think that will help you understand my case.
I am trying to explain it via example please also check my attachment as that will help you to understand the case.
eg -for opportunity - OP-123 , on 16-12-2013(by Exp- Today()-15) WIP stage was WIP 5.
So 15 days back for OP-123 WIP stage was WIP 5
and for OP-124 WIP Stage was WIP 4
now if i change vDays to 30.(on date 01/12/2013)
Than for OP-123 WIP stage is - WIP 3
for OP-124 WIP Stage is - WIP 3
i think that will help you understand my case.
Hi,
i used the following script at script level
Temp1:
LOAD
Opporunity,
[Opps stage],
Date,
Date(If(IsNum( Date),Date, $(#vBeginTime))) as FromDate
FROM
(ooxml, embedded labels, table is [Opps History]);
OPP:
LOAD
Opporunity,
[Opps stage],
FromDate,
Date(If( Opporunity=Peek( Opporunity),Peek(FromDate)-0.00000001, $(#vEndTime))) as ToDate
RESIDENT Temp1 Order by Opporunity, FromDate desc ;
DROP Table Temp1;
created a variable vdate attached to input box that will recevie your integer.
and fdate=today()-vdate that will filter WIP AND Opputunity listbox
use two list box one for WIP and another for Oppurtunity
then in each listbox expression write the following expression:
=if(fdate>FromDate and fdate < ToDate,Opporunity)
when you enter a integer through input box vdate will receive and fdate variable will check
in recpective list box.
please see attachment
anant
I think it can work but i want that to work in expression of chart for further Comparison purpose while when i used this expression it provide Multiple values due to which expression show nothing as Multiple value issue occured.
please will you help me how i can use same in Chart.