User Profile

Jacky_C

New Contributor III

Joined 2 years ago

33 Posts5 LikesLikes received1 Solution

View All Badges

User Widgets

Contributions

Re: ABS function in GetDataCell formula
Hi Pete, Thanks for your reply. I tried using GetDataCell(ABS(A#100)), and the value displays correctly. We could revamp our cube views to fix this, but we still want to understand why the ABS func...
1 year ago Place Reporting
50Views
0likes
0Comments
ABS function in GetDataCell formula
Hi all, We encountered an issue with the ABS function in a GetDataCell formula. Our cube view has two rows: the first tagged to account A#100, and the second with the formula GetDataCell(ABS(CVR(Row...
1 year ago Place Reporting
Cube View
dashboards
Reports
86Views
0likes
2Comments
Re: XFGet formulas return #Refresh when used in a large file and the XFGet contains an argument that points to a formula and not a hard coded value. This seems to be especially the case when the XFGet is used to retrieve FxRates. For example: =IF(P5=
HI, I have encountered a similar issue, is it being resolved? Thank you. Jacky
1 year ago Place Reporting
112Views
0likes
0Comments
Re: Unable to retrieve data through XFGet formula
Hi MG, Thank you for reply. I have noticed that the cell shows #REFRESH even when I have clicked both "Refresh sheet" and "Refresh workbook". Hence it leads to the #value error in the excel. ...
1 year ago Place Reporting
235Views
0likes
0Comments
Unable to retrieve data through XFGet formula
Hi all, We have built a excel report which includes multiple xfget formulas. However, an #Value error shown in the cell after refresh (refresh sheet/refresh workbook both are not working). I have al...
1 year ago Place Reporting
Excel Add In
321Views
0likes
2Comments
Re: Running task scheduler on a specific business day each month
Hi, Thank you for your suggestion. As mentioned by TauseefAliKhanB , I am looking for setup these dates dynamically. For example, in Jan, the schedule tasks are between 1st to 7th of January; in Fe...
1 year ago Place Application Build
240Views
1like
0Comments
Running task scheduler on a specific business day each month
Hi all, Can we schedule a task to run on a business day each month, for example, between the 1st and 7th? I know we can set it for specific days and weeks, but is there a way to make it more dynamic...
Solved
1 year ago Place Application Build
Infrastructure
438Views
0likes
4Comments
Re: Disable a button on a dashboard when the form status is 'Completed'
Hi Edwin, Thank you for providing the code and example, this is working as expected on my side as well. I just an additional question on whether this functionality could be leverage on sub-workflow...
1 year ago Place Rules
241Views
0likes
1Comment
Re: Disable a button on a dashboard when the form status is 'Completed'
Hi Edwin, Thank you so much for providing the relevant function and sample code. I am able to create the relevant XFBR rule, but I am not sure how can I store the Form status in a parameter? Is the...
1 year ago Place Rules
286Views
0likes
3Comments
Disable a button on a dashboard when the form status is 'Completed'
Hi all, I am trying to build a business rule to dynamically disable a button (become invisible) once the form status is completed. May I know is there any function I could leverage on to fulfill thi...
Solved
1 year ago Place Rules
XFBR
447Views
0likes
5Comments

Groups

No places to display