Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two excel files contains tablesTab1, Tab2 AS follows
Tab1:
Staffing Profile Identifier | Project num | Project Name | Demand Resource |
707963 | 220981 | QV_Dev | 4 |
707964 | 209892 | QV_Dev | 6 |
707965 | 209892 | QV_Dev | 5 |
Tab2:
Profile Identifier | Project Name | Allocated Resource |
707963 | QV_Dev | 1 |
707963 | QV_Dev | 2 |
707964 | QV_Dev | 3 |
707964 | QV_Dev | 2 |
707965 | QV_Dev | 3 |
But Output will be in PIVOT or STRAIGHT TABLE as follows
Profile Identifier | Project Number | Project Name | Demand Resources | Allocated Resource | Gap |
707963 | 220981 | QV_Dev | 4 | 3 | 1 |
707964 | 209892 | QV_Dev | 6 | 5 | 1 |
707965 | 209892 | QV_Dev | 5 | 3 | 2 |
i tried it using if((Staff Profile Identifier=Position Identifier),Allocated Resource,0) in Expression and i used calculated dimension also, but sometimes it works well and some times got errors.
Please Find attached Screen shots.
PLEASE Can any one look into issue, GIve me Solution.
Thanks,
MVReddy.
Hi,
Can you attach the sample file?
Regards,
Jagan.
Not sure what you've done to your other thread, but AFAIR I tried to answer your question there.
No multiple posts regarding the same issue, please, it makes it hard to follow a discussion.
Hi,
Experts here will love to help resolve this issue. However, you have not provided enough explanation, i.e. what result you want, what the issue is? e.t.c
Kindly provide more information.
From what I can glean from little inforamtion you provided above, it sounds as if you wanted to join both TABS (TAB1 & TAB2) together. If that's the case. I will suggest you use JOIN functionality.
Hope this help and look forward to more explanantion
Best Regards,
Gabriel
Please Respond Anyone to this issue, It's Urgent Requirement!
Thanks To All for Your Valuable Reply,
Now i'm attaching sample QVW and my requirement is 'Position IDentifier' repeated and taking 'Allocated Resources' values repeatedly, but i want only one 'Position IDentifier' value for this i want to add multiple 'Allocated Resources'(Belongs to same 'Position Identifier') and substract them with 'Demand Resource(it's a single value)'
it's Urgent Requirement, i'm waiting for your reply.
Please Respond Anyone to this issue, It's Urgent Requirement!
Thanks,
Reddy
I Added Explonation and sample QVW and Screenshots.
Please give any idea on this.
It's Urgent Requirement.
Thanks,
MV Reddy
Hi swuehl,
I'm sorry about that and now my requirement has been changed thatswhy i posted in Post.
Please look into the issue, it's Urgent.
Thanks,
MV Reddy
See attached example
Thank you very much Gysbert Wassenaar,
This is exactly what i needed, It's working fine but in my QVW for some values i'm getting Error values like "-5.5511151231258e-017", "2.2204460492503e-016", " -4.4408920985006e-016".... ,i attached sample screen shot also.
Rest of all things are working fine.
i tried to replace them with '0', but it didn't work.
I'm attaching my QVW, Please have a look into this issue.
Thanks for your valuable support to us.
Thanks,
MV Reddy
Try using the round or floor function: for example round(AllocatedR-Demand,0.001)