Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to find the share of each budget items by cost. As in the example below
I'm trying to use Set Analysis, but I get the following
Help me please.
Try this:
sum(totalsum)/sum(TOTAL {<[budget items] = {'cost price'}>} totalsum)
Try this:
sum([budget items]) / sum(TOTAL [budget items])
Try this:
sum(totalsum)/sum(TOTAL {<[budget items] = {'cost price'}>} totalsum)
Yeah, I think Sunny is a bit closer to the solution than my initial suggestion.
Create the variable on front end
vCost =sum({<[budget items] = {'cost price'}>} totalsum)
Now write the expression
=sum(totalsum)/$(vCost)