different number types and Totals

Hi there,

2 questions in one post.

I have multiple entities which need a different number formatting.

eg. Days don't need decimals while the rates yes.

share rows should show a % sign at the end.

Any idea how i can manage that? can i do it through rules somehow?

second question - Totals don't make sense any idea how i can do that?

Days should be the sum while shares should be the calculation i used in the procedure.

Thank you!

Find more posts tagged with

@Maik Burghardt, for the decimals and suffix, I would use the Format (if you are using an Entity by row in your screenshot).

After creating the Format, head to the DataView panel on the Screen, and attach the Format/Template to your DataView.

For the Share, depending on your calculation, you might be able to Use a Rule, and Apply on Totals.

@Samir Jones thank you for your response the formatting worked pretty well. :)

Any idea how to alerts for the different entities?

I guess the totals are the biggest challenge because it is just one cube that i am using at the moment and some entities need a different approach.

@Maik Burghardt, did you try using Rules with Apply on Totals?

Yes i did but it didn't do anything probably because the indivudal numbers are calculated in a procedure.