Expression issue with conditions

[shyamcharan]

Hi experts,

I have an expression as below with three conditions to get the latest written down value(WDV) of an asset.

I would need to get the WDV value for an asset that has 'Book' as the Category and the latest WDV determined by the Date ID.

Additionally I would need to filter out the WDV values based on Event Type and I would need only the 'Null' value event types.

=SUM({<DeprCategory={'Book'}, DPDateID = {"$(=max({1} DPDateID))"},[EventType]-={'*'}>}WDV)

But I could not get this working.

Attached is the QVW document that I attached for testing.

Can you please help me with this.

Thanks in advance.

Regards,

Shyam.

[MK_QSL · Accepted solution]

=SUM({<DeprCategory = {'Book'},DPDateID = {'$(=Max(DPDateID))'},AssetID = {"=IsNull(EventType)"}>}WDV)

Or

=SUM({<DeprCategory = {'Book'},DPDateID = {'$(=Max({1}DPDateID))'},AssetID = {"=IsNull(EventType)"}>}WDV)

[shyamcharan]

Thanks Manish.

The first one worked. Not sure why inclusion of {1} in the DPDateID condition did not work.

Thanks heaps.