Delete row

[Anonymous]

     Hello Guys,

Hello Guys,

I am facing one issue, where record number was created for two companies on same date, The expression should be include latest  record in the report .I marked in the color red for the required record in the attached screen capture. Please check it and suggest me.

Regards,

Krishna

[jaumecf23]

In the affected expression, set the total mode as it says the screenshot :

[Anonymous]

Hello Jaume,

The final value will be expression total because the value should match to KPI value, Anyway still same result  after selecting your suggested option. Need a condition which excludes if same record found in two places.

Regards,

Krishna

[jaumecf23]

Maybe you can use the Dimensionality() function and do an expression formula for the total expression

[Anonymous]

Hello Jaume,

Can you provide me one example of Dimensionality() function ,please

Regards,

Krishna

[jaumecf23]

Something like this :

if(Dimensionality()=0, expression for total, actual expression)