My fiscal year and quarter are custom as shown below and in string format:
FiscalQuarterName:
How do I calculate the period-over-period difference for the custom quarters mentioned above?
periodOverPeriodDifference(sum(BillableHours), ?? ,QUARTER,1)
Hi
You have to define the custom quarters and then have to find difference manually
like bill amount of Q1,Q2 and so, then find the difference between each quarter.
Thanks for your response.
My requirement is to display the difference between quarter bills and add a conditional format dynamically saying if 10% increase than last quarter , mark it green or red etc…
For that you can use conditional formatting and add conditions as per your requirement.
Try using ‘Difference’ function
difference(
sum( {Billable hours} ),
[{Quarter} ASC],
1,
[{Any other aggregation field(optional}]
)
Hi @Asfak,
It’s been awhile since we last heard from you. Were you able to try Gojo’s suggestion and did it work for your case or do you have any additional questions?
If we do not hear back within the next 3 days, I’ll go ahead and close the topic.
Thank you!
Hi @Asfak,
Since we have not heard back from you, I’ll go ahead and mark the solution. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!