Hi, I have an Advanced Chart where I am displaying dates. The values,
however, are stored as ticks(Long). This is great for the bars and
points, however, I need the Axis labels to be displayed as date (not
Long see below). I've tried a few versions o...
Hi, I have a matrix data source matrixed on Account. Sample below. One
of the Account fields is a Date that I need to convert to a Long to
store. I can do the conversion but not sure how to target the value to
convert when in a matrixed data source. ...
Hi, I have a CV Form where the input is a "Date" Cell Type. I need to
use the date to translate to a OS Time Period. I am struggling with
using the Date value in a Business Rule. It only returns an Integer and
I can't seem to convert the integer to a...
hi, I tried to pass the datetime values to the chart, but can't seem to
do it. I can pass as a string, but that is not helpful. Below is the BR
and Chart config. thanks Dim oSeriesCollection As New
Hi, we actually have over 300 Account columns in the source file with
various data types. I was finally able to get this to work. First I had
to ignore any columns with no data. Then before the return statement I
had to add: api.ValueIsnumeric = True...
unfortunately args.value is still only pulling the Account names and not
the values. I am putting the Rule on the Account1 column. It seems it is
only pulling the related Dimension values. When I use args.line on the
Amount, surprisingly I can at lea...
hi Jack thanks for the reply. I had tried args.value and args.line but
those only return the header row (Args.Value=Account1; Args.Line=Code1,
Entity, Account1, Account2, Account3) I'm not quite sure how to use
GetFieldValuesForSourceDataRow but I ca...