Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot chart where I am trying to calculate a field called available capacity.. But this based on a variable and another field.
I want to say:
if vshowearnedhours=1
then
if pooled=' ' sum (availablecapacity)
or if pooled='x'
sum availablecapacity/count (distinct [work center])
I tried doing set analysis and here is what I have but it is not working at all..
=if($(vShowEarnedHours),
Sum({$<Poolk={''}>}AvailableCapacity) + sum({$<Poolk={'X'}>}AvailableCapacity/Count(DISTINCT [Work Center])))
May be try this?
=If($(vShowEarnedHours) = 1,
If(Len(Trim(Poolk)) = 0, Sum(AvailableCapacity),
If(Poolk = 'X', sum(AvailableCapacity)/Count(DISTINCT [Work Center]))))
thanks, but does not work.. no results..
Would you be able to share a sample or some sample data to show what exactly are you trying to achieve? May be knowing the input and output might help me better understand the issue and give you a solution.
Best,
Sunny
Try Something like this.
=Sum({$<ShowEarnedHours={1},Poolk={''}>}AvailableCapacity)
+
Sum({$<ShowEarnedHours={1},Poolk={'X'}>}AvailableCapacity/Count(DISTINCT [Work Center]))