Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please suggest how can I calculate Sum of QTY_VAL and multiply by selected day bucket .
sum(QTY_VAL) * [day bucket]
How to create day bucket, which will count days only for selection, like if i select 5 days in calendar then bucket should be for 5 days, if i change selection then days count will change
Hi,
Try something like this
Count( distinct DATE)
You may be better off creating and uploading a small sample QVF app file to illustrate your requirement and ensure accurate and relevant help. It does not need to be real data, but it should reflect the fields and tables of the real app and include the table you want and exactly what results you would lie to see.
Hi Deepak,
Try this sample:
Br,
KC
There is no sample mentioned
Hi ,
I have attached a qvf file.
You can try this exp also:
if(GetSelectedCount(Date)=0,Sum(Sale),
Sum(Sale)*GetSelectedCount(Date)
)
Br,
KC