Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 columns - ID and Velocity
Velocity is calculated from variables and a complex expression.. Sum(....V1.)
I'm trying to get the relative percentage for every value in velocity but unable to.
I have tried velocity/Sum(Velocity) .. but not working.
i can see the partial sums in the pivot.
I'm wondering why only Sum() operation is not working.
Can anyone pls help me.
Hi Hampus Andersson,
I just removed all the variables in the velocity and typed the full expression, SUM() worked for the column.
Thanks for your reply.
From my next posts, i will be asking the question with sample data.
Thanks for your time.
Hi Mark,
I think a small file with sample data would be great beneficial here as its really hard troubleshooting your problem based on current information.
Good luck!
Hi Hampus Andersson,
I just removed all the variables in the velocity and typed the full expression, SUM() worked for the column.
Thanks for your reply.
From my next posts, i will be asking the question with sample data.
Thanks for your time.