Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hallo everybody,
I need your help for a set dimension in a dimension. I need the last date for a special criteria as dimension.
I use the max function but this doesnot work.
Can anybody help me.
One sample for my formula:
if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE))
Thanks and greetings Sven
if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE' and INVT_TRANS_DETAIL.TRAN_DATE=$(=max(INVT_TRANS_DETAIL.TRAN_DATE)), INVT_TRANS_DETAIL.TRAN_DATE)
May be like:
Aggr(if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE)) , INVT_TRANS_DETAIL.TRAN_CODE)
Or,
Aggr (Max({<NVT_TRANS_DETAIL.TRAN_CODE={'SPRECEIVE'}>}INVT_TRANS_DETAIL.TRAN_DATE),INVT_TRANS_DETAIL.TRAN_CODE)
Note: Aggr() might not be required if you want the result in a text box
thanks for your answer, but this formula does not work for my pirotable
Can you post an example .qvw? It's almost impossible to help without one.