Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day everyone,
I am making a profit loss statement for a client of mine,
I already got this far:
Now iWould have to get a percentage as a second measure.
This percentage should represent the number divided by the number shown next to "OMZET" = 345.640 for 2018
OMZET is the total amount of the 70 accounts. So that every measures shows how much percent it takes from the OMZET.
Any ideas how?
To achieve the above, I already had to make an excel for the parameters, wich accounts to use.
Thanks in advance
Dries
This is what i'm trying right now:
if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet)) &' '& if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet))
/
if(SubRubriek = 'Omzet', if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet))) &' '& if(SubRubriek = 'Omzet', if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet)))
Hi,
calculate
Your Expression / sum({<Rubriek = {OMZET}>} total value)
and format it to decimal in numbers
Regards
Hello,
if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet)) &' '& if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet))
/
sum({<SubRubriek = {'Omzet'}>} total value )
This returns the same number as the original formule x 100
1. instead of reply your expression you can use label of the expression
2. sum (total value) is a placeholder for your correct expression
Hello,
already many thanks,
but I don't understand.
So like this?
if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet)) &' '& if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet))
/
sum({<SubRubriek = {'Omzet'}>} total if(sum(Debet) > sum(Credit), sum(Credit) - sum(Debet)) &' '& if(sum(Credit) > sum(Debet), sum(Credit) - sum(Debet)))
hello,
I think it has something to do with negative outcome.
The + numbers are correct,
but the - numbers show an insane percentage.