You need to sign in to do that
Don't have an account?
Alex Valavanis 10
Formulas in salesforce
Hello, i want to create the following calculations in my reports. Can you please tell me the formula?
I have summarized the "Subscription Start Year" by Year . Shall i include these formulas as fields so that i can then drag and drop in the reports?
As you can see there are both numbers and values. These are the formulas i'm using in excel.
1. IF (Net amount=0,"New",0)
2. IF(Net amount>0, Net amount>0)), "Renewed",0)
3. IF (Net amount=0,"Not Renewed",0)
4. IF (Net amount 2015 =0,Net amount 2016 ,0)
5. IF((AND(Net amount>0,Net amount>0)),Net amount,0)
I have summarized the "Subscription Start Year" by Year . Shall i include these formulas as fields so that i can then drag and drop in the reports?
As you can see there are both numbers and values. These are the formulas i'm using in excel.
1. IF (Net amount=0,"New",0)
2. IF(Net amount>0, Net amount>0)), "Renewed",0)
3. IF (Net amount=0,"Not Renewed",0)
4. IF (Net amount 2015 =0,Net amount 2016 ,0)
5. IF((AND(Net amount>0,Net amount>0)),Net amount,0)