Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello check the sample data (attached with this post)
I have a project, and billable days with revision number
I want to calculate the total billable days where Revision Type = 0 - Reference Budget or Revision Name = Reference Budget and Revision number is the last one
so in this case the revision number is 4 and the total should be 745
I wrote the following expression:
sum(aggr(
sum(
{
<
[Revision Number]={"=[Revision Number] = max({<[Budget Revision Type]={[0 - Reference Budget]}>+<[Budget Revision Name]={[Reference Budget]}>}[Revision Number])"}
,Frozen={1}
>
}
[Billbale Days]
)
,ProjectId))
but the number is completely wrong