Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Sure this is an easy one, what I am trying to do is for each user I want to use their effort and mutliple it by a variable - each user has a variable assigned to it. I originally used Set Analysis but this may need tweaking. It works fine when looking at an overview of all users, and when you change the variable value the chart changes - but when you select an individual user it still shows the overview.
What I really need, is something that will change when I select user(s) and to multiple their effort by the variable.
This is what I currently have:
sum({$<SUN_OwnerAccount = {'User1'}>} vRB*SUN_IH_EffortTime)+
sum({$<SUN_OwnerAccount = {'User2'}>} vHSJ*SUN_IH_EffortTime)+
sum({$<SUN_OwnerAccount = {'User3'}>} vPA*SUN_IH_EffortTime)+
sum({$<SUN_OwnerAccount = {'User4'}>} vPB*SUN_IH_EffortTime)+
sum({$<SUN_OwnerAccount = {'User5'}>} vMH*SUN_IH_EffortTime)+
sum({$<SUN_OwnerAccount = {'User6'}>} vDL*SUN_IH_EffortTime)
I'm hoping that you can tweak my set which would do it, but I'm happy to change how I achieve these results!
Kind Regards,
Dayna
What if you took the variable out the Sum function?
i.e
sum({$<SUN_OwnerAccount = {'User1'}>} SUN_IH_EffortTime ) * vRB + ...
Hello Gareth,
Same again, doesn't change the values when I select one of the users...
Kind Regards,
Dayna
The expression I suggested overides the selections ie User 1 is set etc.
What you should need in this case is =sum(SUN_IH_EffortTime) * vRB
Regards
Gareth
Hello Gareth,
vRB is applicable to only User1, User2 has a different variable assigned, so I dont want all users to be mutliplied by vRB, only User1 (hence the Set Analysis).
Kind Regards,
Dayna
I am sure someone else may be able to explain this better but here goes:
The Expression which will not change regardless of your User selections is as follows:
sum({$<SUN_OwnerAccount = {'User1'}>} SUN_IH_EffortTime ) * vRB +
sum({$<SUN_OwnerAccount = {'User2'}>} SUN_IH_EffortTime ) * vHSJ +
sum({$<SUN_OwnerAccount = {'User5'}>} SUN_IH_EffortTime ) * vMH +
sum({$<SUN_OwnerAccount = {'User6'}>} SUN_IH_EffortTime ) * vDL .
There may be a better way out there but my only suggestion would be to try set users as variables and make selections using selection boxes. Sorry but further than this i beyond me at this stage...
;(
sum({$<SUN_OwnerAccount = {'User3'}>} SUN_IH_EffortTime ) * vPA +
sum({$<SUN_OwnerAccount = {'User4'}>} SUN_IH_EffortTime ) * vPB +