05-11-2018 1:57 PM - edited 02-04-2024 3:10 AM
Hello All,
i am facing issue with a formula
Pay/rec Voted
REC 1.00
REC 104,250.00
REC 0.00
PAY 20,000.00
PAY 1,700.00
PAY 20,000.00
PAY 2,000.00
-----------------------------------
1,47,951
-----------------------------------
I need to find sum on PAY and REC. So i have written the formula like this.
If Pay/rec = 'REC'
then sum (Voted ) .
With this i need to get only REC Amount i.e 1,04,251.00
But i am getting 1,47,951.00.Can you please let me know where am i doing a mistake.
Thanks
Radhika
Hello Abhilash,
Thanks for your reply. I didnt get the second step. Can you please tell me where i have to click ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Radhika,
1. Modify the formula as:
If {Pay_Rec} = 'REC' Then {Voted}
2. Go to the Insert Summary option > Choose this formula field as the Field to Summarize > Place it on the Report Footer if you need a grand total or place it on the Group Footer if you need subtotal of a group.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.