Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 29, 2020 11:46 AM
Hello,
I have one table that has both insurance and investment products. The Product field splits these out. They share other common fields such as “Payment/Investment_Amount” and “Payment_Frequency”
Payment frequency holds single select options of weekly,biweekly, bimonthly, and monthly.
I am trying to create a statement specifically to calculate annual premium paid for insurance products. This is a conditional IF statement as the product has to equal insurance, then if it does, premium amount * frequency to equal annual payments.
Can someone assist? Much appreciated!
Thank you,
Ben
0 Replies 0