topic Re: Use Field Value in another field in Set analysis in App Development

Use Field Value in another field in Set analysis

RichardRozgonyi — Wed, 05 Mar 2025 10:59:00 GMT

Hello everyone,

Could someone please help me.
I need help with the following calculation.
I would like to calculate the amounts per mandate no. before the last login.

I have already tried with many formulas without success.
All data is in a table in the script.

Thanks in advance.

Re: Use Field Value in another field in Set analysis

PrashantSangle — Wed, 05 Mar 2025 11:13:12 GMT

Can you share sample data?

Re: Use Field Value in another field in Set analysis

PrashantSangle — Wed, 05 Mar 2025 11:24:50 GMT

Try below

chart Type - Table

dimension - mandate_nr, last_login

Expression1 - Sum(value)

Expression2- Sum(if(invoice_date<last_login,value,0))

Regards,

Prashant Sangle

Re: Use Field Value in another field in Set analysis

RichardRozgonyi — Wed, 05 Mar 2025 12:34:52 GMT

The answer is very good thank you, works perfectly.
I didn't see the forest because of the tree in front of it (I was thinking too complicated).

Thank you very much Prashant Sangle

Re: Use Field Value in another field in Set analysis

RichardRozgonyi — Wed, 05 Mar 2025 12:45:31 GMT

Hello,

I would like to know the following.
I also have a calendar bound to the data model.
In Expression1 - Sum(value) (calendar is taken into account)
IExpression2- Sum(if(invoice_date<last_login,value,0)) (calendar should not be taken into account)
How do I do this?

BR Richard

Re: Use Field Value in another field in Set analysis

PrashantSangle — Wed, 05 Mar 2025 13:45:28 GMT

Can you explain little bit more with example

Re: Use Field Value in another field in Set analysis

RichardRozgonyi — Wed, 05 Mar 2025 13:52:11 GMT

I have found the solution. Thank you very much for your help.

Sum({<Year=, Month=>}if(invoice_date<last_login,value,0))