Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to create a field that shows every line of my balance as a sales percentage, for example:
Account Real % of Sales
Sales 200 100%
Costs -40 -20%
Total 60 30%
I´m trying to create an expression "% of Sales" like this:
=sum(Real)/(Sum( {$<[Account]={Sales}>} Real))
But I just get this:
Account Real % of Sales
Sales 200 100%
Costs -40
Total 60 30%
In the DB, both Sales and Costs are in the same column (Account).
Thanks for your help!!
I´m using this, but the result is the same(got the same values):
=sum(Real)/(Sum(total<Month>{$<[Cuenta Resu]={'Sales'}>} Real))
Thanks
Just to be sure, 'Month' is your month field name? Because every field else is named in spanish...
Could you post a small sample application here?
You are right I translated some words trying to make it more understandable Month is my Month field name, the exact line right now is:
=sum(Real)/(Sum( total{$<[Cuenta Resu]={'Ventas'}>} Real))
This line gives me the Sales participation percentage of every line and works fine when I have the information agregated.
Now I would like to use the variable Month to separate de data on Months columns. I did this and it looks fine but a closer look you can see that the sales (and all the other fields separated by moths) are being divided by the total sales not just the month sales wich result on a smaller participation % than what should be.
I´m attaching a sample app, hope is clear enough
Thanks,
Camilo
So this is not what you want to see?
Mes | 1 | 1 | 2 | 2 | 3 | 3 |
Cuenta | Real | Sales % | Real | Sales % | Real | Sales % |
Costo1 | 130 | 43,3% | 110 | 27,5% | 98 | 25,8% |
Costo2 | 30 | 10,0% | 60 | 15,0% | 77 | 20,3% |
Ventas | 300 | 100,0% | 400 | 100,0% | 380 | 100,0% |
Yes that is what I want to see!
Yes - this is not what you want or yes - it is?
This is my expression:
=sum(Real)/(Sum( total<Mes> {$<Cuenta={'Ventas'}>} Real))
Looks similar to what I suggested before, doesn't it
Stefan,
How can I create that table???
Thanks,
Camilo
Yes that is what I want !!
Sorry I didn´t see you had already answered, I try your solution but it doesn´t show any data...
Here you are, I justed added the <Mes> after total in % expression.
It works perfectly!! I had an error on a variable.
Thanks Stefan!
Camilo