I already done the formula's (refered within the same excel) and calculate option is in manual and now need to calculate formula's in big size(100 mb) excel through Altreyx tool, Because in excel taking too much time. if anybody knows the solution kindly help me on this...
Solved! Go to Solution.
Hi,
with related to the workflow u shared is very much helpful for me, thanks alot.
but the priority of workflow you considered as "Opening stock sheet" because of that some combinations is missing for calculations. the reason is
* Combinations not having Opening stock but having KEPH - CK40N(COGM) & Cockpit Report(COGS)
Hence can you please revise that workflow to consider Cockpit Report sheet(COGS) as a base and following other sheets (Opening Stock & KEPH - CK40N sheets).
I here with attaching the workflow.
Almost at end stage, facing this issue. Kindly help me out.
Hi,
with related to the workflow u shared is very much helpful for me, thanks alot.
but the priority of workflow you considered as "Opening stock sheet" because of that some combinations is missing for calculations. the reason is
* Combinations not having Opening stock but having KEPH - CK40N(COGM) & Cockpit Report(COGS)
Hence can you please revise that workflow to consider Cockpit Report sheet(COGS) as a base and following other sheets (Opening Stock & KEPH - CK40N sheets).
I here with attaching the workflow.
Almost at end stage, facing this issue. Kindly help me out.
Hi @nadanl,
Attached is a version with the joins switched around so that Opening Stock is the last sheet joined on.
Kane
Hi,
Thank your very much...
ur master...
Oh still no of combinations matching with Openg stock sheet only, Hence combinations are missing. here i show the sample numbers which i faced as a mismatches
Details | No of Plant materials | Remarks |
As per "workflow Output" | 43232 | 8594 Plant mats combinations missing from the output |
As per "Cockpit report sheet" | 51826 | count as per Input file |
As per "Opening stock sheet" | 43232 | count as per Input file |
As per "KEPH - CK40N sheet" | 51826 | count as per Input file |
Kindly help me on this..
The expectation is "Cockpit report sheet" combinations as a base priority and then plot other sheets then do the calculations.
Now the output : all the Plant materials combinations from Opening stock sheet as 0 value even though its having value.
but previously its processing correctly.
Expectations is
* The materials available in all the sheets (Opening stock sheet, KEPH-CK40N sheet & Cockpit sheet) ==> The calculation should happen and displayed in output file
* The materials available in 2 of the sheets (KEPH-CK40N sheet & Cockpit sheet) but not available in Opening stock sheet hence ==> Opening value considered as 0, then calculation should happen and displayed in output file
Please help me on this.
Are you saying that some of the opening stock values are now zero.... That's my bad, I put a sample tool in so that the Opening Stock sheet was not equivalent to the others. You can right-click on the sample tool and select 'Delete and connect around'. I only had it in there to try and make the sample data closer to yours.
ya its working fine.. thank you very much... :)
sorry for the late reply.
Hi,
Have 1 doubt, is it possible to transpose the costs (cost components 1 to 40) rows again to columns (like a input file)?
becase of the transpose the line items are more than 20 lacs if we are doing the functions like input file layout it wil be reduced.
Can you please help me on this.