Forum Discussion
How to get the difference between two days column with one column having dynamic value
Hi all,
I have made two columns, no. of days which is the difference between start date and end date and the total number of days, the first value in total number of days is the total of no. of days, the second value is the difference between total days and no. of days but the third value should come from the new total days - no. of days and so on. I made a calculated column which is
Hello @deekshasingh,
Sounds like a mobile calculation requirement, maybe you can try to set the filter condition no less than or equal to the current index, then these calculations should be rolling in the current and previous records.
If you are still confused about the encoding formula, please share some dummy data then we can try it.
How to get answers to your question quickly
Best regardsXiaoxin Sheng
2 Replies
- lbendlin
Super User
For each "row" in your virtual table (filter context) you need to compute all previous "row" values since they depend on each other.
Provide sample data in usable form and show expected outcome so we can suggest an appropriate aggregation function (like SUMX) to accomplish that.
Hello @deekshasingh,
Sounds like a mobile calculation requirement, maybe you can try to set the filter condition no less than or equal to the current index, then these calculations should be rolling in the current and previous records.
If you are still confused about the encoding formula, please share some dummy data then we can try it.
How to get answers to your question quickly
Best regardsXiaoxin Sheng
