Hello,
Could you please help to solve the condition with following dataset:
Venture Purpose Value
1 Forecast 100
2 Planned 200
3 Actual 0
The purpose is to set the condition only for Venture "1" , the rest (2 & 3) will use all the time "Planned" variable from the Purpose column and corresponding value.
For the Venture "1" I need to use "Forecast" if the value exist, otherwise use "Planned" if there is a value or use Actual (as a last resort) if both Forecast and Planned will be equal to zero (null or empty cell).
Thanks,
Solved! Go to Solution.
Hi #TonyA,
Thank you for support,
I applied your workflow, but got issues with missing the data in Cross Tab output. This data after applying Cross tab the data in the input partially miss its content, since method for aggregating has been selected "First", but I need all values kept as it is.
This is Cross tab input data:
Cross tab Output:
Could you please advise, whether there are another aggregation methods that does keep all values in place?
Thanks,
Not sure what you're looking for. Can you provide a sample input and the complete desired output? It looks like you gave me the result only for venture 1.
Hi #TonyaA, I could solve the issue finally by trying different options and accepted your previous solution as solved, since generally it worked.Thanks!
Now I have another issue, I will try to search for similar case, otherwise will post separately.
Kind regards