ContributionsMost RecentMost LikesSolutionsRe: Conditional Formatting to Show "0" I think you may have to change the formula to round off values to 0. Even if conditional formatting is able to make it zero, it would not impact calculation as it would still go ahead and calculate l...OneStream Admin Copilot? Hi Community, do we have a onestream admin copilot? i recently came across copilot for azure sql database and was really impressed by DBA capabilities. I was wondering if OneStream has similar produc...Re: Allocation thanksJackLacava! hope OP finds this useful, i have one query in above code is writing Line 11 optional as we are sort of clearing sourcePov in line 10 and if we don't write line 10, then will line...Re: "YTD" like calculation but for custom periods Thanksdb_pdx, for getting cumulative numbers till 2023M6 i also used V#YTD:T#2023M6 and it worked! Re: Allocation attempted this, but unsure if my OFFSET is correct: api.Data.Calculate("E#B:O#Forms:A#100001:UD5#ADJ = 0.5 *(E#A:O#Import:F#EndBal_Load:A#100001:UD5#ADJ",False) api.Data.Calculate("E#C:O#Forms:A#...Re: "YTD" like calculation but for custom periods This is the code that gets cumulative number from specific month its very rough so don't like it: For monthIndex As Integer = 1 To 6 cumulativeAmount += api.Data.GetDataCell("T#"..."YTD" like calculation but for custom periods I am writing a member formula/dynamic BR where i have to get 'YTD" like cumulative members but instead get it from month 7 onwards i.e. if i want to get cumulative data from month 7 onwards, i wrote ...Re: Rule Rules - ONLY write rules when necessary. thank you sir, most important thing to remember Re: CubeView Performance - OneStream Dashboard Vs FDX Thank you Sai, this should work Re: CubeView Performance - OneStream Dashboard Vs FDX Thank youSai_Maganti I tried using this. I am running the following to get data from DU, but unable to get results limited to filter i have applied, is there any thing wrong how i am passing the fl...
