My Weekly question!
I am creating a report that I want to display the percentage of a total figure. eg. the following displays all credit card transactions.
2% of total credit card transactions = ??
I’m not sure what the syntax would be to get this calculation to display. I’ve looked through the forum for something similar but am struggling. Once I’ve understood it in my example hopefully I will have a clearer idea.
Many Thanks
Pretty sure it would be something like this;
[=F({ACCOUNT TRANSACTION TOTAL:Payment Transaction:Credit Card}/100*2)]
the /100*2 being the 2% calculation and [=F(xxxx)] being the tag/syntax for a calculation.
Cheers - that works
OK - so it wasn’t as easy as I had hoped I would find it
The following gives me the figure I want.
I then want to add that figure to another figure and display the result.
How do I add these 2 together and display the result? (These are just examples) which will help me get my final report together.
Thanks as always
RickH
March 18, 2016, 8:13pm
5
Been a while since i messed with expressions but try
[=F({ACCOUNT TRANSACTION TOTAL:Payment Transaction:Credit Card}/100*2)]+[=F({ACCOUNT TOTAL:Cash})]
Not sure if thats right as the + is outside the =F’s
I would have guessed;
[=F({ACCOUNT TRANSACTION TOTAL:Payment Transaction:Credit Card}/100*2+{ACCOUNT TOTAL:Cash})]
In theory the multiply and divide should be done before the addition. alternaivly adding brackets would contain the multiply and divide;
[=F(({ACCOUNT TRANSACTION TOTAL:Payment Transaction:Credit Card}/100*2)+{ACCOUNT TOTAL:Cash})]
sorted - thanks once again - I was getting lost in a world of brackets!
RickH
March 19, 2016, 1:14am
8
Should work with the + outside the brackets thats how all my expressions are and they work
The plus outside the square brackets??
RickH
March 19, 2016, 9:25am
10
Yep im sure all the expressions i use have plus and minus etc outside the square brackets. Ill double check but pretty certain
now I can see it I can adapt it for other stuff! your a star!
