User Profile

Jacky_C

New Contributor III

Joined 2 years ago

33 Posts4 Likes1 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...
13 days ago Place Reporting
9Views
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...
16 days ago Place Reporting
Cube View
Dashboards
Reports
21Views
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
25 days ago Place Reporting
38Views
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. ...
25 days ago Place Reporting
54Views
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...
26 days ago Place Reporting
Excel Add In
78Views
0likes
2Comments
Re: Running task scheduler on a specific business day each month
Hi, Thank you for your suggestion. As mentioned byTauseefAliKhanB, I am looking for setup these dates dynamically. For example, in Jan, the schedule tasks are between 1st to 7th of January; in Fe...
30 days ago Place Application Build
111Views
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
2 months ago Place Application Build
Infrastructure
188Views
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...
2 months ago Place Rules
208Views
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...
2 months ago Place Rules
232Views
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
2 months ago Place Rules
XFBR
286Views
0likes
5Comments

Groups

No places to display