topic Two Different selections on a field and find the differences on selected field values in App Development

Two Different selections on a field and find the differences on selected field values

kpradeep5610 — Fri, 02 Apr 2021 08:26:45 GMT

Hi All,

please help me to find out the below problem.

i have a field Which is "DATE_Field" in this if i select any two dates on my interest it will give the differences between on those selected dates

Example

WeekAsOn

24-apr-2020

17-apr-2020

10-apr -2020

31-may-2020

Please help me to find it

Regards,

Pradeep K.

Re: Two Different selections on a field and find the differences on selected field values

Taoufiq_Zarra — Tue, 19 May 2020 15:19:07 GMT

I hope this example will help you.

=Date#(Subfield(concat(WeekAsOn,','),',',2),'DD-MMM-YYYY')-Date#(Subfield(concat(WeekAsOn,','),',',1),'DD-MMM-YYYY')

Re: Two Different selections on a field and find the differences on selected field values

kpradeep5610 — Thu, 21 May 2020 08:39:08 GMT

Hi Zarra,

Thanks for reply

i'm not getting the differences on two selections, because of here i'm using 3 measures. and please follow the attached png image for reference. and please tell me what is your measures.

Regards,

Pradeep K.