Member since ‎06-27-2022

User Statistics

  • 46 Posts
  • 0 Solutions
  • 1 Kudos given
  • 1 Kudos received

User Activity

Hi SAC Experts,In a SAC story, I tried to create input control based on the calculated measure. This measure appeared in the list of available measures but didn't filter the table (I wanted only lines with 1 to be present).The measure calculation ref...
Hello,For the SAC story, I need to calculate for any chosen date, not only for today/current server date:an employee's age based on the date of birthan employee's tenure based on the job starting dateMy model has two dimensions: Employee and Date (da...
Hi,Please advise me on how to make an advanced formula to move sales planning data to the P&L model.The Sales planning model is dimensioned by Projects. Each Project has properties: BusinessLine, CostCenter and RevenueAccount.P&L Model is dimensioned...
Hello,How can I create a Calculated Measure to get data from the next month?I want Next (Jan) = Measure(Feb). I tried to use LOOKUP([Measure], [d/Date] = Next ("Month", 1)) but it gave me no resultThank you   
Hi,What could be the best way to calculate Project Revenue as a calculated measure in SAC?I have a project of several months duration. For each month I have monthly incurred income, but I have to recognize Revenue only at the last month as a sum of a...
Kudos from