- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 18, 2023 06:30 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 18, 2023 06:42 AM
you can try this
IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) , {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})
Rodolfo - RdMedia
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 18, 2023 06:44 AM
I don't think this will work - as above I need the second part to work differently from the first, i.e. if Mini Series is selected the second line to apply.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 18, 2023 06:57 AM
Try this:
IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) ) &
IF({Always On/Miniseries} = "Mini Series", {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})
We can't use commas to separate functions and need to use `&`, so I replaced your comma with it; should work fine
