Forum Discussion
Ignore first row/index calculated column
Hi All,
I am using the below formular:
UR Job Hours Check =
[UR Job Hours] - maxx(filter('Mechanical Allocations', [Job ID] =earlier([Job ID]) && [Index] = earlier([Index]) -1) , [UR Job Hours] )
This formular looks at hours from an individual job id and subtracts the hours from the previous index relating to that job id.
Is there anyway to tweak this formular to ignore the first index of each ID?
Many thanks
Hi Anonymous ,
You don't want to return value when index is 1, right?
Try to add a if condition.
UR Job Hours Check = IF([Index]<>1, [UR Job Hours] - maxx(filter('Mechanical Allocations', [Job ID] =earlier([Job ID]) && [Index] = earlier([Index]) -1) , [UR Job Hours] ))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
You don't want to return value when index is 1, right?
Try to add a if condition.
UR Job Hours Check = IF([Index]<>1, [UR Job Hours] - maxx(filter('Mechanical Allocations', [Job ID] =earlier([Job ID]) && [Index] = earlier([Index]) -1) , [UR Job Hours] ))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.