Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a timestamp field1 (format 26/07/2018 01,26/07/2018 02 etc) also I have got another field2. I need to apply the selected values (lets say if 10 values are selected ) of field1 to field2 in set analysis.Filed1 and field 2 are from different tables joined with date.
Any suggestions are appreciated.
Thanks in advance.
Hi,
here is a set analysis example you can try to apply
{<Field2={"$(=Concat(distinct Field1))"}>}
PS: make sure that both fields are on the same timestamp format
Not really sure, If i understand correctly, But perhaps this?
Sum({<Date1 = {"=Date1 = Date2"}>} Sales)
Or
Sum(If(Date1=Date2, Sales))
May be this
{<Field2 = p(Field1)>}
May be this:
=num(avg({1<Field1={'$(=getfieldselections(Field2))'}>} Sales),'0.00')
=Sum({1<Field1={'$(=getfieldselections(Field2))'}>} Sales).
Lavanya,
Can you provide sample data\App?
Hi All,
Many thanks for your reply. I am still working on this. Will update you all soon.
Thanks again.
Hi All,
Can some one suggest me how to select set of field values of Field 1(timestamp) in Field2.(day)
Let's say I have the timestampvalue (dd/mm/yyyy hh) in Field1 and if the values selected in Field1 are 29/07/2018 00 to 31/07/2018 09. so I need to select the days in field 2 which are 29,30 and 31. Field1 and field2 are in different tables. I would like to make this selection in via button trigger.
Any suggestions are much appreciated.
Thanks in advance.
Not really sure - What your request. Would you like to share work file which is faster than slower response ..
Hi Anil,
Thanks for replying. Please find the sample data attached.