Is it possible to have 2 different formula on the same line item?

Options
kdoan
kdoan Member, ALL USERS, Community Member Posts: 5 Contributor

I am creating a module that needs 2 different formula on a bunch of line item. Basically, if it's Actual, than its formula 1, if it's Forecast than it's formula 2. Is that possible, or am I better of creating 2 different module and using dashboard to create this?

 

I know i can confine the formula to Actual or Forecast in the line item but is it possible to have 2?