Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Staff, Good evening,
I have a table:
I'm riding a PivotTable that need to have a field that Count how many contracts meet the following criteries:
This expression is not working for me
Count({$<CodStatusBx={0}>} fabs(Date(Today(),'DD/MM/YYYY')) - fabs(Date(DtContrato,'DD/MM/YYYY')))
Could help me?
May be this:
Count({$<CodStatusBx={0}, DtContrato = {"$(='>=' & Date(Today() - 10, 'DD/MM/YYYY'))"}>} NuContrato)
May be this:
Count({$<CodStatusBx={0}, DtContrato = {"$(='>=' & Date(Today() - 10, 'DD/MM/YYYY'))"}>} NuContrato)
Thanks for the tip at the end, I had to create the calculation in Table before loading the data to get the correct result, Thank you Sunny!