cancel
Showing results for 
Search instead for 
Did you mean: 

Condtional Report

Former Member
0 Kudos

Hi ,

I want display the records based on value enter in the prevoious report .

In my capex planning ..all assets are enter by user and approve is one of the coloumn in every asset .

User enter the value 1 for approve and 0 for reject .

in next report i am callucating budget based on approved assets .

i know if we define membeset on property , it will display the records .but ..approve is not property it is value enter in the previousreport .

Ex:

first report : Aseet -life-unit--status

111 -


10--2--- 1 ( approve)

222--5-5-----0 ( reject )

333--10-4-------1 ( approve)

second report : i want display only approved records for callucating budget

Aseet -life-unit--status

111 -


10--2--- 1 ( approve)

333--10-4-------1 ( approve)

pls let me know how to display based on condtion on value .

Regards,

PSR

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I would think of this process as capturing a value entered to an account by a DataSrc. So, if you have an Account called CapexApproved and submit the value of 1 to the intersection, by a datasrc memebr of Approved_Assets, then it is easy to run a new report of the assets that have been both approved and submit by having a report that is EVDRE based on the above parameters.

Hope this helps.

Answers (1)

Answers (1)

0 Kudos

Hi PSR,

I dont think you can do this. As we cant write any formula in expansion memberset.

Hope it helps

Raman