on 03-10-2023 9:43 AM
Hi,
Here is the scenario:
I want to achieve YTD calculation in Analysis for Office excel addin by pulling model from SAC. I was able to achieve YTD calculation using restricted measures in SAC story but can I do the same calculation in Excel using Analysis for Office Addin?
Anyone who has faced this kind of similar issues or knows the workaround in this csae, their comments would be deeply appreciated.
azm_azm
I haven't tried it on a SAC Source but AFO does offer some calculation option. May be you can explore with SAC model as source.
Also you could create a calculated measure in SAC to give YTD numbers and then just report that measure in AFO.
Example below of YTD for measure [AMOUNT]
ITERATE(IF([d/Date].[p/MONTHDESC]="Jan" ,0 , PRIOR () ) + [AMOUNT], [AMOUNT], [d/Date].[p/CALMONTH])
Hope this helps !!
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.